Forum Discussion
Solved
Dynamically rename columns from a column names table
Let's say I have a table with 3 columns: TableName, ColumnNameOld, ColumnNameNew. I create two functions that filter TableName to the table I want, and I keep either ColumnNameOld or ColumnNameNew a...
im not sure i understand what exactly you need but perhaps List.Zip will be of help
Table.RenameColumns( Source, List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
im not sure i understand what exactly you need but perhaps List.Zip will be of help
Table.RenameColumns(
Source,
List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } )
)Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
Thank you! What a wonderful function! 🙂
This also has led me to this:
https://excel.city/2017/11/how-to-use-list-zip-in-power-query/
And this:
Both very useful for these kind of things.