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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,111 questions
{count} votes