Cannot use parameter in derived column to update row
Leo Yip
1
Reputation point
Hi there,
I first to use alter row to find the row that needs to update. (my condition: if null)
Then, use derived column to update the field, using the parameter as the field value.
But the derived column cannot identify the parameter(name: $CurrentID) as a string value that used to update, and it identify it as the column name.
Then it return:
Column 'abc00000010' not found
But it is a value!
Please help.
Sign in to answer