Forum Discussion

IanDavies's avatar
IanDavies
Icon for Helper III rankHelper III
1 year ago
Solved

Merging multiple tables (more than two) to create a single list of assets

I have data from a number of sources about computers in the business, not all sources havr all computers (ergo not all computers are in all sources) I need to merge the data so that overlapping da...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi IanDavies ,

    I create three tables as you mentioned.

    Then I think you need to make relationships among them.

    Next you can go to Power Query and use Append.

    You can remove duplicates and use Merge Queries.

     

     

     

    Best Regards

    Yilong Zhou

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi IanDavies ,

I create three tables as you mentioned.

Then I think you need to make relationships among them.

Next you can go to Power Query and use Append.

You can remove duplicates and use Merge Queries.

 

 

 

Best Regards

Yilong Zhou

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

  • IanDavies's avatar
    IanDavies
    Icon for Helper III rankHelper III
    1 year ago

    Tahbnk you, I hadnt considerd doing the append followed by the merge ... that is more elegant than my solution.