Passing the Dataflow Parameter to Sink Key column in Azure Data factory

Question

I wanted to implement SCD type 2 logic but using dynamic tables and dynamic key fields from Config Table, I have a challenge to pass the Data Flow Parameter as Sink Key Column for my Alter Row activity, it is not taking the parameter values and always gives the error as invalid key column name, I tried picking the Dataflow parameter for the expression builder at sink key column and trying to pass the value from alter row transformation and I have named the field with parameter in the select statement as well , any help or suggestion highly appreciated

Please clink below image Sample How I wanted to Pass Dynamic Values in Sink Mapping Trying to Give the Dynamic Value to Key Value

Answer 1

You have "List of columns" selected, so ADF is looking for a column in your target table that is literally called "$TargetPK1Parameter".

Change the selector to "Custom expression" and enter a string array parameter. The parameter can be an array of strings that represent names of key columns in your target table.

It should look something like this: