Dynamic value - Datatable filter

Help
, ,
1

Hello Everyone,

How do I filter the datatable with a dynamic value? Instead of a known(static) value, I would like to filter it based on the value I get from the for loop

Ex: dt1.select("[‘Column7’]=row.item(3).tostring).copytodatatable()

Is it possible?

Thanks
Selva

2

There is an activity available Data Table Filter.
Try to use that.
Thanks

3

Will that allow dynamic value? I know it allows static value but will it allow dynamic values? Moreover I only see “Filter Table”, I don’t see any activity with “Data Table filter”

4

So try to use in a loop

5

When I use row.item(1).tostring as a criteria to filter, it doesn’t accept. throws an error

6

filter
filter855×382 18.7 KB

7

Actually this is not available in my studio. I am using 2017.1.6682 enterprise version

8

Assign a DataRow dr=dt.Rows(0)
use for each
for each item in dr.ItemArray
WriteLine(item(0).tostring)

So try to use this.