How to map column names of one table to the value of attributes (Same Column Names in other table)?

[Amar-Agnihotri]

Hi,

I have almost 400+ custom columns in a table as customfield_10750, customfield_10890 and so on. 

Table 1

and i created another table with same column nams as attributes and their values as 

Table 2

Now i want to replace all the column names in table 1 with the values of the attributes in table two.

Can anybody suggest how can i achieve this in Power query 

Thanks 

[wdx223_Daniel · Accepted solution]

if there is no missing value between Attributes values and comlumn names of Table1, then this code may work

NewStep=Table.RenameColumns(Table1,Table.ToRows(Table2))

otherwise, try this code

=Table.RenameColumns(Table1,List.Select(Table.ToRows(Table2),each List.Contains(Table.ColumnNames(Table1),_{0},(x,y)=>x{0}=y)))

[Amar-Agnihotri]

HI @wdx223_Daniel 

I tried this but getting this error

  

This is my Custom_Fields table 

and this is my Actual Table in which i want to replace column names 

I am not able to understand why it is throwing this error. 

[wdx223_Daniel]

is it possible that there two or more "Enviroment" in the second column of Custom_Fields?

[Amar-Agnihotri]

Yes Exactly this is happening. See this 
Some values are repeating for same custom field

[Amar-Agnihotri]

Hi @wdx223_Daniel ,

I think there is something bad with the data in Custom_Fields. For now i have remove duplicates from the Custom_Fields second column and now everything is fine 😊. Out of 413 rows 408 values left after removing duplicates so i need to check for those 5 duplicate values again.  Thanks for your help and i am accepting your answer as solution 👍

[Amar-Agnihotri]

@wdx223_Daniel 

thanks for the reply. I will check this and wll tell you about the result 😊