Dynamic value - Datatable filter

datatable
excel
studio

#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


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