Forum Discussion

polman4's avatar
polman4
Icon for Helper I rankHelper I
4 years ago

Merge 3 tables (Append?)

Hello,   I have 3 different tables that I would like to merge into one. Actually from what I understand i need to do an append query but everything I tried is not working fine.   Below you find t...
Need Help
polman4's avatar
polman4
Icon for Helper I rankHelper I
4 years ago

Hello KNP,

 

Thank you a lot for the reply and the example!

 

What troubles me is that the 3 tables i have don't have the same structure. For example table 2 is missing Inventory Column. From what i've seen you are using as base "storeA" table at your example with 

= Table.ColumnNames(StoreA)

 

So (i guess) i can't just append the 2nd and 3rd table to first since the structure isn't the same. Maybe a 1 to 1 matching is needed?

 

Thank you,

Grigoris