Sort DataTable with 'Assign' activity

Help Activities
, ,
1

Hi,

I have a DataTable, in which one column contains values from 0 to 30.
I would like to make a ‘Assign’ activity to filter data greater then 0.
Please help me to make a value to ‘Assign’ Activity with VB.

2

Hi,

Do you want to filter datatable or sort datatable?

Filter

dt = dt.AsEnumerable.Where(Function(r) Double.Parse(r("Column1").ToString)>0).CopyToDataTable()

Filter and Sort

dt = dt.AsEnumerable.Where(Function(r) Double.Parse(r("Column1").ToString)>0).OrderBy(Function(r) Double.Parse(r("Column1").ToString)).CopyToDataTable()

Regards,

3

@Yoichi Thank you for your help!