Forum Discussion

dehmos27's avatar
dehmos27
Frequent Visitor
7 years ago
Solved

How can I replace table column names before expanding data from multiple tables in a folder?

I am combining multiple tables in a folder. I am at the point where I can click Expand Data and expand all of the columsn. However, I need to rename some of the columns before expanding. Is there a w...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago

    No problem, this should look like so then:

     

    Table.TransformColumns(<PreviousStepName>, {{"Data", each Table.RenameColumns(_, Table.ToRows(Mappings), MissingField.Ignore)}})
ImkeF's avatar
ImkeF
Community Champion
7 years ago

No problem, this should look like so then:

 

Table.TransformColumns(<PreviousStepName>, {{"Data", each Table.RenameColumns(_, Table.ToRows(Mappings), MissingField.Ignore)}})
dehmos27's avatar
dehmos27
Frequent Visitor
7 years ago

ImkeF, all I can say is "Wow!" both to the speed of your response and to the solution. That worked like a charm. Thank you so very much. I was banging my head against a wall trying to figure that out.