Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data from two sharepoint lists. The one list went over 5000 items and we had to create a new list for new data. The lists are identicle in structure, but have different data in them. How do I simply join the old and new records in to a new table.
e.g
Table: 1 Table 2
ID Data ID Data
1 xyz 1 fre
2 xse 2 bbg
3 dft 3 frt
Required
Table 3
ID Data
1 xyz
2 xse
3 dft
1 fre
2 bbg
3 frt
Many thanks
Troy
Solved! Go to Solution.
In "Edit Queries", select Table1, choose Append Queries - Append Queries as New - enter Table2 as the second table, OK and rename the new query to Tabe3.
Code generated:
let Source = Table.Combine({Table1, Table2}) in Source
Alternatively, you can create a new blank query, enter in the formula bar: = Table1 & Table2, rename the new query to Table3.
In "Edit Queries", select Table1, choose Append Queries - Append Queries as New - enter Table2 as the second table, OK and rename the new query to Tabe3.
Code generated:
let Source = Table.Combine({Table1, Table2}) in Source
Alternatively, you can create a new blank query, enter in the formula bar: = Table1 & Table2, rename the new query to Table3.