topic Re: Dynamically rename column based on a mapping table in Developer

Dynamically rename column based on a mapping table

tranpeter — Thu, 29 Sep 2022 20:32:36 GMT

Hi,

I currently have in my database a table that looks like this:

We also have another table that provides the descriptive mapping for each generic column name. For example, CUSTOMER_ATTR_1 can be GEOGRAPHY for one customer and it can be COLOR for another customer.

When I display on PowerBI the data from the VALID_CUSTOMER_DATA.CUSTOMER_ATTR_1, I want to display CUSTOMER_INDUSTRY_ID. For CUSTOMER_ATTR_2, I want to display CUSTOMER_SALES_SEGMENT and for CUSTOMER_ATTR_3, I want to display GUIDANCE_GROUP.

Is this dynamic renaming of columns based on a mapping table doable in PowerBI?

Thank you!

-Peter

Re: Dynamically rename column based on a mapping table

tranpeter — Thu, 29 Sep 2022 23:30:33 GMT

A coworker pointed me to this solution. I'll have to give it a try and update this post on whether this worked.

Re: Dynamically rename column based on a mapping table

Anonymous — Fri, 30 Sep 2022 01:56:22 GMT

Hi @tranpeter ,

You can refer the following links to rename column names dynamically:

Dynamically rename columns from a column names table

Table.RenameColumns( Source, List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } ) )

Using M to dynamically change column names in PowerQuery

Dynamic Column Names in Power Query

Any comment or problem, please feel free to let me know.

Best Regards

Re: Dynamically rename column based on a mapping table

Anonymous — Thu, 06 Oct 2022 05:02:47 GMT

Hi @tranpeter ,

Did you get it worked? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards