question

LeoYip-6125 avatar image
0 Votes"
LeoYip-6125 asked ShaikMaheer-MSFT commented

Cannot use parameter in derived column to update row

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
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LeoYip-6125 ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

Alter row transformation helps to you to apply policies on source or transformed data to mark them for insert or update or delete based on defined conditions and then perform the changes accordingly on sink data.

It would be great help if you can share few snippets of your implementation, so that we can understand better on requirement and unblock you with errors.

  • When you say my condition if null, do you mean in your source if any column value for a row is null then consider that row for update based on some ID key ?

  • Derived column helps to add new column or modify existing column data. Could you please share more details with some snippets about derived column usage in your scenario?


Between, Kindly check below link to know more about Alter row transformation.
https://docs.microsoft.com/en-us/azure/data-factory/data-flow-alter-row

0 Votes 0 ·

Hi @LeoYip-6125 ,

Could you please share clarifications mentioned in above comment? That will help us to follow along issue and provide detailed resolution. Thank you

0 Votes 0 ·

Hi @LeoYip-6125 ,

Did you get chance to share details about above requested clarifications. Details on clarifications will help us to follow along issue and provide detailed resolution. Thank you

0 Votes 0 ·

0 Answers