Forum Discussion
Helper ICombining info from two tables to make one big table
Hi I have two tables. I need to take the info from both tables and make one big table. No row should be a duplicate however if it is I do not want it to combine I just want both to be there. I saw a Union function in DAX but my rows are not in the same order and I also am not sure how to work that. Wondering if im on the right track. Could this also be done in a relationship? If so what woud the relationship cardinality be?
You can follow these steps and learn how to append two or more tables in powerquery
https://learn.microsoft.com/en-us/power-query/append-queries
4 Replies
- ChielFaber
Super User
You can follow these steps and learn how to append two or more tables in powerquery
https://learn.microsoft.com/en-us/power-query/append-queries
- ChielFaber
My advice would be to use the UI of powerquery. Just rearrange the columns in power query editor to ensure the columns of both tables are in the same order. Then use the append fuction in the UI to get the result you want.
If you have duplicate rows you can also easily remove these through the powerquery UI with the remove duplicates function.
This would probably solve your problem in a few clicks
- AlienSx
Hello, ChielFaber column names matter, not their order.
nhodgesHi! Thank you, would you mind providing a screenshot, im not sure how use append function or to rearrange
