Select multiple value from column

Help
1

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
2

@Viorica_Marga,

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

3

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
Cattura853×392 16.4 KB
Cattura

4

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

5

@Viorica_Marga,

Use Filter DataTable activity and pass your dataTable as input.

image
image787×505 12.6 KB

1 Like
6

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

7

@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.

8

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:

2 Likes
9

Pass the parameter as List and then put a for each loop for the Filter Data Table activity.

image

10

@Viorica_Marga i have the same issue

What you did to solve it?

I’m afraid the other responses don’t have so much sense… it has to be a dynamic value in the filter

I guess it should be done with a LINQ function

11

Whatever the scenario may be or even if you need to filter dynamically, the above all solutions will work @pablo.sanchez,

Not sure why you think they all doesn’t make sense. Have you tried or you just mentioned that straight away

1 Like
12

@pablo.sanchez

Yes all the above solution should work.
You pass the value to the filter data table activity.

image
image551×671 19.6 KB

1 Like