<Need you help> Data processing in transforming the status

[shuanbai]

Hello guys,

I have 2 folders,

folder A contains those reports/excel in which REQs are closed by HR in past years,

folder B contains those reports in which REQs are opened for hiring until now.

I will run these two reports monthly, and append them into 1 sheet.  called "append sheet"

Question:

in April, REQ 34590 are listed in open- reqs report / in folder B.

in May,  we have successfully hired 1 guy for REQ 34590, then it will be listed in closed-Reqs reports/ in folder A.

In "Append sheet' of May ,there will be 2 rows for REQ 34590, one row comes from open-REQ report, the other one comes form closed-REQ report. how can I eliminate the record in open- reqs report?

[v-yangliu-msft]

Hi  @shuanbai ,

 If you only want a column, you can use merge queries in power query to select the merged column

Best Regards

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @shuanbai 

If you supply some data as a file or a table (copy/paste into this forum) it will make it easier to help you.

I don't know what your data structure is so I'm guessing here, but you could try Grouping by REQ number in the Appended query.  This will leave you with 1 record per REQ number.

Please supply data so I can supply a better answer.

regards

Phil