Forum Discussion
Renaming columns in PQ : We expected a RenameOperations value
Thanks, BA_Pete ,
Navigation step outcome as follows:
So per MS documentation : "A replacement operation renames consists of a list of two values, the old column name and new column name, provided in a list."
So still do not get where the issue resides..
Fair enough, looks fine.
The only thing I can think that might cause this particular error would be if your list pairs were not all being formed correctly, i.e. if one of the pair values evaluated to null/integer/special character somehow.
Have you tried clicking on every one of your nested lists in your Navigation step to ensure that each one includes two valid values?
Another issue sometimes occurs when you have more pair values in your lists than columns in the table (or the old names don't match), but I don't think that would throw this error.
Pete
I was getting this error as long as my renames list contained null within some of the pairs, e.g. {"oldNameX",null}. As this was a consequence of List.Zipping two lists of uneqal lenghts, the solution was to trim the lists to same size. After, the error was gone - even though the renames list was in fact shorter than the count of columns to be renamed. The rest simply stayed unrenamed, without any error.
