Filter table based on datatype

[shreyaank]

how do i filter data data column based on datatype? I want a column filled with only integer values and not any other data type like string or float.

[JosephNehl]

You can use a build data table activity to specify which columns should be which type. When creating the columns in this activity in the table you can set it to integer, string, or any other data type. Doing this would make sure no data that is any other type can be inserted into that column.

[TimK (Tim Kok)]

Could you provide some example data that might be in the column?

Would the column contain both text and numbers?

[shreyaank]

No i already have data coming in, I am not creating it. the column would contain both integers and Strings, I need to highlight the string which is the odd one out.

[shreyaank]

It could just be a simple column like below. I just need to highlight the odd ones out ie string values which

Column1
23
23
4
5
5
7
7
7
abc
dje
456
233
28
6
75
4
4
dfh

[TimK (Tim Kok)]

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… …

I think that is what you are looking for You can use LinQ to return only Interger values.