PQ - How to append three or more tables with different headers (first table has proper headers)
| sheet 1 |
REGION |
Country Code |
UID |
EMP ID |
NAME |
USD |
|
Result |
|
|
|
|
|
|
data1 |
data2 |
data3 |
data4 |
data5 |
data6 |
|
REGION |
Country Code |
UID |
EMP ID |
NAME |
USD |
|
|
|
|
|
|
|
|
data1 |
data2 |
data3 |
data4 |
data5 |
data6 |
| sheet 2 |
REGION |
Country |
ID |
NAME |
LC |
AMOUNT |
|
data7 |
data8 |
data9 |
data10 |
data11 |
data12 |
|
data7 |
data8 |
data9 |
data10 |
data11 |
data12 |
|
data13 |
data14 |
data15 |
data16 |
data17 |
data18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| sheet 3 |
REGION |
Country |
ID |
EMP |
LC |
AMOUNT |
|
|
|
|
|
|
|
|
data13 |
data14 |
data15 |
data16 |
data17 |
data18 |
|
|
|
|
|
|
|
Code:
let
TFR2 = Table.FromRecords({[REGION = "REGION", Country = "Country Code", ID = "UID", NAME = "EMP ID", LC = "NAME", AMOUNT = "USD"]}),
TFR3 = Table.FromRecords({[REGION = "REGION", Country = "Country Code", ID = "UID", EMP = "EMP ID", LC = "NAME", AMOUNT = "USD"]}),
Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
Source3 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
App2 = Table.Combine({TFR2, Source2}),
App3 = Table.Combine({TFR3, Source3}),
Prom2 = Table.PromoteHeaders(App2, [PromoteAllScalars=true]),
Prom3 = Table.PromoteHeaders(App3, [PromoteAllScalars=true]),
Append = Table.Combine({Source1, Prom2, Prom3})
in
Append
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=oVb1RfcSHLM&lc=UgwTq-jZlZLnLQ5VB8Z4AaABAg.9Hroz-OyWog9tYjSMc1qjA
https://www.youtube.com/watch?v=0pbsf6sox34&lc=Ugxp9JFvvejnqA68W1t4AaABAg
https://www.youtube.com/watch?v=kfQC-sQxMcw&lc=UgyCxQWypNIhG2nUn794AaABAg.9q1p6q7ah839t UQl_92mvg
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg. 9isY3Ezhx4j9itQLuif26T
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg. 9irSL7x4Moh9itTRqL7dQh
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg. 9iraombnLDb9itV80HDpXc
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg. 9is0FSoF2Wi9itWKEvGSSq
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
