Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
troyrowlands
Regular Visitor

add multiple same structure tables into one

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

 

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

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.

Specializing in Power Query Formula Language (M)

View solution in original post

1 REPLY 1
MarcelBeug
Community Champion
Community Champion

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.

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.