Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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