Forum Discussion
Solved
Unable To Apply Query - OLE DB or ODBC error: [Expression:Error] expected a RenameOperations value
When I try to apply this query (see text file) I get the following error: OLE DB or ODBC error: [Expression:Error] We expected a RenameOperations value I think the error stems from t...
I'd probably choose to null all fields if there aren't exactly 3.
Something like this:
renamedrecord = if Record.FieldCount(sortedrecord) <> 3 then [Storage_Key = null, Network_Key = null, Condition_Key = null] else Record.RenameFields(sortedrecord, <...existing code here...> )
It's hard to say without being able to see it in action, but if thisrecord has more or less than three fields, then I'd expect the renaming step to fail since you'd get invalid oldname/newname pair(s) from List.Zip.