Number Filter UiPath

[Real.Downey (Jr)]

hello, I want to save the list of users whose score is above 200 in Excel using filter data table. The program does not give an error but does not perform the operation I want, how can I fix it?

[muhammedyuzuak]

Hi @Real.Downey,

Since the data received from Excel is not int type, it may not be filtering.

Can you convert the column type to number for test?

Regards,
MY

[Real.Downey (Jr)]

how can i do this i am a bit of a beginner

[muhammedyuzuak]

**Note: Remember that you are doing this to find out the source of the problem.

1.select the entire column
2.Go to the Format area.
3.Select the number format.

Save the excel and try again.

Regards,
MY

[RajKumar_DC (RajKumar Durai)]

Hi @Real.Downey ,

What about select Query

Input:

Output:

Query:

dt.Select("Convert(Col1,System.Int32)>'200'").CopyToDataTable

Workflow:

Thanks,

[Real.Downey (Jr)]

I got an error like this when I wrote it here
Assign: Input string was not in a correct format.

[Anil_G (Anil Gorthi)]

@Real.Downey

Try this

Dt.AsEnumerable.Where(function(x) if(IsNumeric(x("Number").ToString.Trim),cdbl(x("Number").ToString.Trim),0) > 200).CopyToDataTable

Gope this helps

Cheers