How to filter but with dynamic columns

The columns to filter are from my config file.

For example i want to filter by datatable by col1 = ‘a’ and col2 = ‘b’, but maybe in the next run i will filter by col3 = ‘a’ instead, all this is based on what the user input in config file

you can use the below instead of using filter datatable activity. You can create a variable to be passed into the argument of dt.Select() and the value of the variable can be based on the config file
dt.Select("[col1]='a' AND [col2]='a'")

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.