Filterdatatable convert string into Int

[Gokul001 (Gokul Balaji)]

Hi @tharani.natarajan

1. Use Read range activity → Store it as DtInput

2. Use Filter Data Table activity → To remove the empty rows in the excel file and store the result in DtOutput

3. Use Assign activity and try with this expression

How about this expression?

DtResult = Dtoutput.AsEnumerable().Where(Function (x) CDbl(x("Amount").toString.Trim) > 0).CopyToDataTable

Check out this XAML file

FilterAmountGreaterThanZero.xaml (8.7 KB)

Output

Regards
Gokul