Check Numeric or not in Filter DataTable

I want to check the column is numeric or not in Filter DataTable.
How to check it?Thanks!

Hi @Soe_Min_Latt

I think you are trying to get/verify the datatype of column, it is not p[possible using filter DataTable activity.

You can use following code

string strDataType = DT.Rows(0).item(0).GetType.ToString


1 Like

Hello @Soe_Min_Latt
If you want sort all the Numerics you can do it using For Each Row and For Each Activity please check this simple workflow It’ll sort out all the int to a different sheet
FilteringNumber.xaml (12.2 KB)
If you only want to check its Datatype you can use Pratikg’s code and add counter to it

1 Like