Issue with filter datatable

Help
1

Hi guys,

I want to filter a data table based on a value of a column,
I wrote:
“ColumntName”<“10”
but id didn^t work.
Any Idea how to deal with Integers in this filter?

Thanks in advnace

2

Use dataTable1.select(“[Column1]<10”)

1 Like
3

is it not possible to use filter data table acitivity?

4

You can use the same activity. I just tried and is working fine.

Remove the double quotes in column filter value and try.

“ColumnName”<10

5

Also if your numbers are not in stored as integer or double in the table this might not work

7

Try it now

Process - Copy.xaml (10.7 KB)

8

still the same it shows nothing

9

You need to provide the Output Columns which you require in Output Datatable.

image

10

no it’s not mandatory, since I wamted to keep all columns.
but I tried it anyway

image
image951×682 37.6 KB

and I have nothing, the filter doesn’t work.
image
image735×480 27.8 KB

11

I checked it. No output. “WIID” column is considered as String. So we need to convert it to Int32 before we filter. We dont have that functionality in Filter DataTable. But Select statement can do it.

dataTable1.select(“Convert([WIID],system.int32)<10 AND [Status]=‘Open’”)

2 Likes
12

hello Vivek,

Is that a data table ? or I have to add at the end .CopyToDataTable?

13

This will give you Array of Rows as output. You can use .CopyToDatatable to convert to Datatable

14

Itired this : ExtractDataTable.select(“Convert([WIID],system.int32)<10 AND [Status]=‘Open’”).CopyToDataTable
but it says cannot find column [‘Open’] any Idea?

image
image903×424 46.6 KB

15

Can you send the screenshot of your select statement. It seems like you have given [‘open’] instead of [Status]

16

yes that was it, thank you so much for your help :slight_smile: I apreciate it

1 Like
17

Great…:grinning:

Please mark the solution as Solved