Forum Discussion
Error when editing column names in Advanced Query Editor
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.
Hi Anonymous
Can you send me the file or the M Code for the same.
Anonymous I don't think I can share the data due to data security issues, but I am wondering if it could be that adding those two additional columns throws off the value positions of the columns(e.g. Value1, Value2, etc.) and that is what is causing the issue since those value numbers are referred to when changing type in later query steps. But if that is the case, do you happen to know in what order the columns are numbered?
HI Anonymous
The columns are sequenced as per the query.
I may be able to help if you can send the M code for the same.
Go to advance editor copy the code, this doesn't have the data.
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 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?