Forum Discussion
Power Query Scrubbing- Business Case
I have a variety of data sources, that are all received form an emailed excel file (unfortunately I cannot connect driectly to database). I have no problem joining them together and using power q...
Hi Anonymous,
From your description, could you mean to add new data to the old table? If so, you could append your data list and remove the duplicate columns:
Sample data:Table A
Table B
Append as new:
Remove the duplicate columns and you could get the result:
Regards,
Daniel He
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi v-danhe-msft
yes, that would solve most of the issues, I think in order to track how many projects were removed (from the new vs old) I would need to just keep track of how many total rows in both sheets, and subtract from each other.