Forum Discussion

troyrowlands's avatar
troyrowlands
Regular Visitor
9 years ago
Solved

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

 

Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    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.

1 Reply

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    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.