rename column headers of nested tabled with same column name

[monojchakrab]

Hiya good people of PQ,

I am trying to rename a few nested tables as below :

I am using the following steps :

• first have extracted the column headers
• then taken the same to excel and added a column for renames

• Taken the excel table back to PQ
• Used, table.renamecolumns ,

Table.AddColumn(#"Removed Columns1", "TableRenames", each Table.RenameColumns([ChangedFKHeaders],Table.ToRows(Headers),MissingField.Ignore))​

but :

bcos a few of the tables have the same column name, I am getting the followng error :

Is there any fix for this unless I am missing something obvious?

any help appreciated

[v-stephen-msft]

Hi @monojchakrab ,

This error is because you are adding a column named "value", but this column already exists in your table. You need to check your table to see if there is already a column named "value".

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.           

[monojchakrab]

@v-stephen-msft - Stephen....that is what is confusing. The table returning the error does not actually contain any column with header as "Value"