Expression. Error The field already exists in the record

[Harmeet25]

Dear Members,

I am getting below error while renaming the columns names using renamed table list.

Expression.Error: The field 'Stock_Code_No.' already exists in the record.
Details:
Name=Stock_Code_No.
Value=

Below is the SS of power query error.

Requesting for your assistance.

Thank you,

Harmeet

[Anonymous · Accepted solution]

Hi @Harmeet25 ,

The reason is that the renamed column name duplicates the column name of another column in the table.

Check the logic or catch the error.

each try Table.RenameColumns([Legit Col Count],Table.ToRows(Renames),MissingField.Ignore) otherwise [Legit Col Count]

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Harmeet25]

Thank you Gao for your support. Really appreciate.