Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
3 years ago
Solved

expression error "field-name" already exists while renaming column headers

Hey good people, I am getting a strange error as captioned above, in the query which was working fine till some time ago. Here is a table, with a column of tables, in which I am trying to insert a ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi monojchakrab ,

 

Maybe the blog and the similar post could help you.

Efficiently rename columns with a function in Power BI and Power Query (thebiccountant.com)

Solved: Dynamically rename columns from a column names tab... - Microsoft Power BI Community

It works fine on my sample.

= Table.AddColumn(#"Added Custom", "Custom.1", each Table.RenameColumns(
   [Data],
    {"Name", "NewColumn"},
    MissingField.Ignore
))

You can download my attachment for details. 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.