Forum Discussion
Expression. Error The field already exists in the record
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
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 TeamIf 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
2 Replies
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 TeamIf 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
Thank you Gao for your support. Really appreciate.
