0

I am trying to build ADF data flow select operation to dynamically select column names. I am receiving required column names in an array parameter named 'colNames' and then I am trying to use that in data flow expression to check if column name in the schema matching any of required column names in an array, then only use that. But its not working , its not selecting any of columns .

contains($colNames,#item==name)

looks like the inbuilt expression 'name' is not the same as that I am trying to use in contains method

enter image description here

KBR
  • 464
  • 1
  • 7
  • 24

1 Answers1

0

In a SELECT activity expression, $$ refers to the column name, so use that in your contains statement:

contains($colName,$$)
Joel Cochran
  • 7,139
  • 2
  • 30
  • 43