Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error when editing column names in Advanced Query Editor

Two columns were added to the source table which have the same names that columns already loaded were changed to. So I went into the Advanced editor and changed the names of the already loaded column...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    I don't see any issues with the M code no that you have suffixed the names with "old".

     

    I was in a similar situation and I did create a new connection to the file and on the new connection I replaced the M code shared by you.

     

    Can you give it a try If it doesn't work you have to give the file used in it with only one row and you can replace all the values in that row with test data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

I don't see any issues with the M code no that you have suffixed the names with "old".

 

I was in a similar situation and I did create a new connection to the file and on the new connection I replaced the M code shared by you.

 

Can you give it a try If it doesn't work you have to give the file used in it with only one row and you can replace all the values in that row with test data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous so I should create a new connection to the same data source and then go to the advanced editor and insert this M code? 

 

Would changing the name of the new columns in the source data to something other than the named that the old columns were originally changed to also solve the issue?