Reply
ME_Evaluation
New Member
Partially syndicated - Outbound

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. Due to the size of both lists (and to keep the data modeling clean) I'd like to use the Advance Editor, but I'm not having any luck. 

 

Is it possible to use the Rename Columns coding but instead of a static list, it references a table (or two columns in a table) in the second field? It's essentiallys an if-this-than-that problem I think. Thank you

 

Table.RenameColumns(Source, {Titles Table}, MissingField.Ignore)

 

master data sheet.png

Column Names.png

 

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

Syndicated - Outbound

Hi @ME_Evaluation 

 

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

3 REPLIES 3
OwenAuger
Super User
Super User

Syndicated - Outbound

Hi @ME_Evaluation 

 

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Syndicated - Outbound

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.

 

Gokul_G16
Resolver I
Resolver I

Syndicated - Outbound

Hi @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 .

Gokul_G16_0-1672979706939.png
Else try below.

Gokul_G16_1-1672979823062.png

 you can selcet you want to chnage first rows want to see headrs' .

thanks 
gokul

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)