Pass an array variable as the value parameter for filter data table

Help
1

Hi all,

I have a large data table having about 96000+ entries, However I need the rows that have only certain values in the columns, each column can have about 5 - 6 unique entries that is required.
Is it possible to store these unique values in an array and pass it into the value parameter of filter data table.

2

yes you can write select query on your table, then you will be having filtered array of data row

  • loop the array and whatever the values you want you can add them to list using Add to collection activity.
1 Like
3

Thanks @Divyashreem, I will try it .

1 Like