Filterdatatable convert string into Int

Hi @tharani.natarajan ,

Maybe there are empty values in the data. How would you want to handle them? The below expression doesn’t include it in the Output (Assuming it is considered to be 0).

Could you check the below Expression :

Dt_Amount.AsEnumerable.Where(Function(x)x("Amount").ToString.IsNumeric andAlso CDbl(x("Amount").ToString)>0).CopyToDatatable
1 Like