Forum Discussion

robbieD's avatar
robbieD
New Member
4 years ago
Solved

Append only shows first selected table data properly

Hi All   I am in power query section of the excel and i have created two subset tables from one very large data set. Imperial_Table (blue color table) and _Metric_Table (orange color table). I am b...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You could use Table.FromColumns instead of appending:

    Table.FromColumns(
    Table.ToColumns(Table_Imperial) & Table.ToColumns(Table_Metric),
    Table.ColumnNames(Table_Imperial) & Table.ColumnNames(Table_Metric)
)

     

    This splits both tables into a list of columns, joins the resulting lists, and then reassembles them into a single table using the column names from each table.

robbieD's avatar
robbieD
New Member
4 years ago

Thank you so much taking the time to respond. I guess then my question was wrong. I apologize for that. All I want in my final table to is to bring selected tables side by side to make a "joined" table by rearranging the columns in that final table as shown in the screenshots. I want to go from 1st picutre to 2nd picture. I dont want to disturb the column arrangement of Master file (first picture) as its a downloaded copy from the internet .

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

You could use Table.FromColumns instead of appending:

Table.FromColumns(
    Table.ToColumns(Table_Imperial) & Table.ToColumns(Table_Metric),
    Table.ColumnNames(Table_Imperial) & Table.ColumnNames(Table_Metric)
)

 

This splits both tables into a list of columns, joins the resulting lists, and then reassembles them into a single table using the column names from each table.