Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cleaning up column headers

Hi All, 

 

I am cleaning up column headers I have the following on a merged query:

Some of the columns from the original tables are slightly different

 

I am cleaning up the 'questions' and I am using the following code:

#"Renamed Columns" = Table.RenameColumns(#"Added Custom",Table.ToRows(#"Course Fields"))

 

Survey Question StatusSurvey Question Status
Survey Questions StatusSurvey Question Status

 

I am getting the following error:

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

 

Anyone know how to amend the code to enable it to handle the duplicates and merge them to the correct name?

1 Reply