Select multiple value from column

Good morning,
how can i select multiple value array [string] from one column and after to filter them.

Thanks for your help
Have a good day

1 Like

@Viorica_Marga,

Could you please tell more details. So that, we will help you.

Thanks,

I need to filter data table, but the filter wizard doesn’t work with array of string.
I made a variable that contain the value of a column name “result”.
After i need to make a datat table, and filter that data table, and do a for reach row for found the row that contain the value searchstring and print the row with the value

Cattura

Use filter data table instead of the array and you can assign multiples values for the same column or row in the condition

@Viorica_Marga,

Use Filter DataTable activity and pass your dataTable as input.

1 Like

Thanks,

i think to do this, but if in future i have a more value, this is not really workable.
Existing something different to make work?
Thanks

@Viorica_Marga,

You can try below one:

DataTable.select(“Result = ‘ok’ AND Result = ‘yess’ AND Result = ‘no’ AND Result = ‘black’”).CopyToDataTable

We have to add condition whenever we need to filter based on new condition. I think we don’t have any other option.

Have you found a solution to this? I’m also looking at the same problem and one thing I’m considering is using the IN operator on a DataTable.Select query.

DataTable.Select("[Result] IN (‘ok’,‘No’,‘yes’,‘black’)")

Thing here is you have to dynamically build the IN query argument to cater to multiple values in the future.

If only there’s an operation called IN or LIKE within the Filter Wizard activity that would allow us to pass arrays!

ETA: I made a blog post tutorial about this solution here :slight_smile:

1 Like