Forum Discussion
Solved
Use Table to Replace Column Headers
Hello. I'm putting some Census data into a report, and the headers on the master data sheet are abbreviations that I'd like to swap out for their understandable titles that are in a seperate table. D...
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
Gokul_G16
Resolver I
Resolver IHi ME_Evaluation ,
Please find the snap.Here you can directly double click the header it show's one dialog box then you can change column headers .
Else try below.
you can selcet you want to chnage first rows want to see headrs' .
thanks
gokul