Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combining columns from different Tables but in same orders

Dear Community Members,    Request your help with below query -   I have 14 tables with similar data and 5 columns per table   Example of two tables below:   Table 1 Cif ID Name 1711 ...
Need Help
Tips and Tricks
Tutorial Requests
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    This pattern should work:

    let
    Source =
    Table.SelectColumns(
        Table.Combine(
            {
                Table.RenameColumns(Table1, {{"ID1", "ID_Output"}, {"Name1", "Name_Output"}}),
                Table.RenameColumns(Table2, {{"ID2", "ID_Output"}, {"Name2", "Name_Output"}}),
                Table.RenameColumns(Table3, {{"ID3", "ID_Output"}, {"Name3", "Name_Output"}})
            }
        ),
        {"ID_Output", "Name_Output"}
    )
in
    Source

    Update the column names as appropriate for your situation.

ImkeF's avatar
ImkeF
Community Champion
4 years ago

Hi Anonymous ,
please try the following instead:

= Table.Combine({
Table.RenameColumns(
Table.SelectColumns(#"Table 1","CIF Id", "Name") ,{{"CIF Id","CIF ID", "Name"}})
,
Table.RenameColumns(
Table.SelectColumns(#"Table 2","CRN", "Name") ,{{"CRN","CIF ID", "Name"}})
})



  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    It give below error:

     

    We cannot convert the value "Name" to type Number.