Forum Discussion

Harmeet25's avatar
Harmeet25
Regular Visitor
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Harmeet25
Regular Visitor
3 years ago

Thank you Gao for your support. Really appreciate.