I got data from browser in variable Extract datatable, using filter option i can maniculate only text field by using filter database.i can’t able to use < or > because it is a string.
I use assign activity to fetch data WIID fileld.
Select statment is “ExtractDataTable.Select(“WIID<‘500000’”).CopyToDatatable”
Iam getting an runtime error “WIID field not found”.
Can anyone please advise?
Can you try using this
ExtractDataTable.Select(“Int32.Parse((WIID))<Int32.Parse(‘500000’)”).CopyToDataTable
Check this below code, @NC_Vignesh
ExtractDataTable.Select(Function(x) Cint(x(“WIID”).ToString.Trim) < 500000).CopyToDataTable
ExtractDataTable.AsEnumerable.Where(Function(r)( Convert.ToInt32(r(“WIID”).ToString)< 500000 )).CopyToDataTable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
