Forum Discussion
combine two tables into one
Hi,
I have two tables with same number or columns and same column names. (Using SQL to pull the data) I would like to combine them into one table. They both have unique identifiers and dont have any duplicates.
table one has 300 rows
table two has 200 rows
The combined table should have 500 rows
How do I do that?
Thanks,
Daven
Hello @Daven - You can do this in Power Query
Transform Data > Select Table1, choose Append Queries (top banner)- Append queries as new - type Table2 as the second table, OK, and rename the new query to Table3.
Tabla1:
Table 2:
Table 3: (Add as new)
I hope this helps.
Bless you
-Namish B
2 Replies
Hello @Daven - You can do this in Power Query
Transform Data > Select Table1, choose Append Queries (top banner)- Append queries as new - type Table2 as the second table, OK, and rename the new query to Table3.
Tabla1:
Table 2:
Table 3: (Add as new)
I hope this helps.
Bless you
-Namish B
- AlB
Community Champion
Hi Anonymous
NewTable = UNION (Table1, Table2)Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
