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

Question

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 column of the same tables, but with renamed headers :Table.AddColumn(SourceTables, "Custom", each Table.RenameColumns([Data],RenameHeaders,MissingField.Ignore))The RenameHeaders is a list of listThe table is as below :and the field structure in one the tables for illustration is as below :&nbsp;&nbsp;Strangely enough I am getting the following error :&nbsp;Am i getting something wrong : most surprisingly the same exact code in another query is not returning any errorANy help appreciatedregds.,

anonymous · Accepted Answer

Hi&nbsp;monojchakrab&nbsp;,
&nbsp;
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.&nbsp;

&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

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

1 Reply

Related content

Alternate key name field in my copy activity is "None" and cannot be changed

Why Does Power BI Display "Nov. 1899" When Concatenating Dynamic Column Names with Field Parameters?

Bug: Can't Format "Specific column" for fields with same name

Adobe Analytics Error | The field "name" of the record wasn't found

Help!!! Expression Error