Cannot use parameter in derived column to update row

Leo Yip 1 Reputation point
2021-06-25T10:49:50.307+00:00

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.
9,539 questions
{count} votes