Forum Discussion

andy_vdg's avatar
andy_vdg
Regular Visitor
8 years ago
Solved

Rename columns based on data in another table

Hi  This is similar to https://community.powerbi.com/t5/Desktop/Auto-renaming-columns-based-on-value-in-another-table/m-p/79018#M32937 with some added complexity   I have a rather large table (fro...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    andy_vdg,

     

    Based on my test, you may refer to the following code.

        #"Renamed Columns" = Table.RenameColumns(Source
                                            , Table.ToRows(Table.SelectColumns(Table.AddColumn(Table2, "ID2", each "customfield_" & Text.From([ID]))
                                                                                , {"ID2", "cfname"}))
                                            , MissingField.Ignore)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

andy_vdg,

 

Based on my test, you may refer to the following code.

    #"Renamed Columns" = Table.RenameColumns(Source
                                            , Table.ToRows(Table.SelectColumns(Table.AddColumn(Table2, "ID2", each "customfield_" & Text.From([ID]))
                                                                                , {"ID2", "cfname"}))
                                            , MissingField.Ignore)