Forum Discussion
Use Table to Replace Column Headers
If the columns of Titles Table are in the order <old name>, <new name>, you could create a step like this:
= Table.RenameColumns(Source, Table.ToRows(#"Titles Table"), MissingField.Ignore)If "Titles Table" is a two-column table, Table.ToRows would convert it to a list of lists, each of which contains the items from one row in the same order as the columns.
Note that text comparisons are case-sensitive, so you would need to ensure the case of the original column names matches the case of the values in first column of "Titles Table".
Regards,
Owen
Super User
If the columns of Titles Table are in the order <old name>, <new name>, you could create a step like this:
= Table.RenameColumns(Source, Table.ToRows(#"Titles Table"), MissingField.Ignore)If "Titles Table" is a two-column table, Table.ToRows would convert it to a list of lists, each of which contains the items from one row in the same order as the columns.
Note that text comparisons are case-sensitive, so you would need to ensure the case of the original column names matches the case of the values in first column of "Titles Table".
Regards,
Owen
Thank you. That did the trick, but I did need to close and apply a couple times to get it to take.
Notes for the next person: in the title table, column one should be the old names and column two is the new names.
