Data scrapping only relevant information

[RPA_Learning50 (RPA UIPATH)]

Filter DataTable for integer values only, using LINQ

Hello @efleurent Mostly you get this error when you are trying to use two different datatypes in a query… instead of all the query you have written, you can do your task only by using the Isnumeric method DT.AsEnumerable().Where(Function(r) cstr(r(0)).IsNumeric ).CopyToDataTable Use the above query and let me knwo about it Check this workflow for better understanding Isnumeric.xaml (7.1 KB) EDIT:- this code will work just fine unless and until it hits a blank value from an excel file… …

Using this it was resolved, Thank you!