Addressing content of flow variables as Column Names in Rule-based Row Filter

Hi there @Jo1607,

you can’t use column names stored in flow variables as column names in Rule Engine nodes but there is a workaround!

  • one option is to use Column Expressions node. There you can access column with following syntax column(0), column(1)… Or like this column(flow_variable) where flow_variable is your column name. Combined with simple if() clause you can get additional column upon which you then filter your data

  • another option is to use String Manipulation (Variable) or Variable Expressions node to create complete rule(s) and then use that flow variable in Rule Engine nodes. Check this topic for more.

Hope this helps!

Br,
Ivan

1 Like