how to dynamically transform one activity output and feed in another activity in ADF

Arundhati Sen 151 Reputation points
2023-03-29T13:47:52.91+00:00

If I directly give (@{item().id} @{item().col1} @{item().col2} @{item().name} @{item().col5}) in set variable is gives back result "C0004\t1000\t\tAT020\t1102"

but I give the activity output (@activity('Lookup_DB_column names').output.firstRow.column_names) which holds nothing but the value (@{item().id} @{item().col1} @{item().col2} @{item().name} @{item().col5}) then it is not giving

"C0004\t1000\t\tAT020\t1102"

but (@{item().id} @{item().col1} @{item().col2} @{item().name} @{item().col5} ) only as string.

Is there any way that activity output or parameter value can be dynamically executed to get result out from the value

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