Forum Discussion

algorton's avatar
algorton
Frequent Visitor
3 years ago
Solved

Merge / append two columns from 2 tables

Hi all   I have seen various iterations of this topic on the forums but none meet my sepcific requirement. I have two tables: Table A Name SerialNumber Hostname1 PC0TKV9P Hostname2...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    algorton In your Power Query Editor, edit the query for your 2nd table and remove your OS Version and Manufacturer columns. Then Append the queries.

  • grodriguezb's avatar
    grodriguezb
    3 years ago

    Hi,

     

    Only change the column names in Power Query before the Append. In the table B, instead of 'Device name', switch it to 'Name' (as in the table A) and 'Serial Number' to 'SerialNumber'.

     

    Once Appended, you can keep only these two columns.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

algorton In your Power Query Editor, edit the query for your 2nd table and remove your OS Version and Manufacturer columns. Then Append the queries.

  • algorton's avatar
    algorton
    Frequent Visitor
    3 years ago

    Hi Greg

     

    Thanks for the suggestion, I need the information in table b for other parts of the report; do you think if I copy the table and then perform the optiosn you suggested is the best way to approach this?