Filter table with doule value

[amanda.gondim]

Hello community!

I’m trying to filter a table where only rows that are greater than or equal to a value “X” should be returned. But it doesn’t give me anything back.
See the attached project
Would you help me please

project.json (1.7 KB)

[SenzoD (Senzo Dlomo)]

Open the filter activity and share screenshot of that with us please

[amanda.gondim]

[ppr (Peter Preuss)]

Feel free on trying the following LINQ as an alternate

Assign Activity
dt2 =

(From d in dt1.AsEnumerable
let c1 = d("Descr.......").toString.Trim.ToUpper
Let c2 = d("Novo saldo....").toString.Trim
Where c1.Contains("CAR_DUPL") AND CDbl(c2) >= 500
Select r=d).CopyToDataTable

just complete the column name
ensure that the data is within the expected formats and values

Handling empty results:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…

[amanda.gondim]

Hello!
I need both statements to be true, so I didn’t use the or operator

[ppr (Peter Preuss)]

with the given starter help and the option of Tracing / Prototyping using:

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

you will sort it out and finalize it. We recommend e.g. to dump out the datatable and have a closer look on the content, especially for the relevant rows, which should be on the filter result.

Feel free to share it with us

[postwick (Paul Ostwick)]

The “or” is in the operator >= not the conditions themselves.

[postwick (Paul Ostwick)]

Is the Novo saldo MT column datatype Double?

[ppr (Peter Preuss)]

Thanks @postwick for the hint. So it was accordingly incorporated within the answers

[amanda.gondim]

Due to the error you gave, it is not in the double format, I will have to remove the period and replace it with the comma with a period.

[ppr (Peter Preuss)]

Thats why we trace the Data and inspect values

@amanda.gondim

I will have to remove the period and replace it with the comma with a period.

we would handle the locals

(From d in dt1.AsEnumerable
let c1 = d("Descr.......").toString.Trim.ToUpper
Let c2 = d("Novo saldo....").toString.Trim
Let dp = double.parse(c2, System.Globalization.Cultureinfo.CreatespecificCUlture("es-ES"))
Where c1.Contains("CAR_DUPL") AND dp >= 500
Select r=d).CopyToDataTable

[postwick (Paul Ostwick)]

Commas and periods are irrelevant. I’m asking you what is the datatype of the “Novo saldo MT” column in your datatable.

[amanda.gondim]

The types are strings

[postwick (Paul Ostwick)]

So you’re trying to check a string value in the column with a double value from CDBl(500). Obviously this is not going to work. What you need to do is create a double column then populate it (ie For Each Row, LINQ, etc) with the converted value of the string column. Then your filter will work.