Filter Data Table does not work

Help Solution Accelerators
1

Hello,

I want to filter the following Data Table for values smaller then 600.

The image shows a German data extraction overview window listing various net values, with options to export as CSV or close. (Beschriftet durch KI)
The image shows a German data extraction overview window listing various net values, with options to export as CSV or close. (Beschriftet durch KI)608×539 9.64 KB

The filter ist set up like this:

This image shows a filtration assistant window for a data table, where rows with a "Nettowert" (net value) less than 600 are being filtered out. (Beschriftet durch KI)
This image shows a filtration assistant window for a data table, where rows with a "Nettowert" (net value) less than 600 are being filtered out. (Beschriftet durch KI)610×376 12.5 KB

However in the unfiltered list are 20 values and in the filtered list as well.

Has anybody an idea what i am doing wrong?

2

Hi @VLC

Use the below LINQ Expression in Assign activity,

- Assign -> dt_Output = dt_Input.asenumerable.where(Function(X) Cdec(X("Nettowert").toString.replace(",",""))<600).Copytodatatable()

Hope it helps!!

1 Like
3

@VLC,

It could happen due to datatype difference in column and 600.

Use assign activity to filter it using LINQ like below.

filteredDataTable = (From row In inputDataTable.AsEnumerable() 
                             Where IsNumeric(row("Nettowert").ToString()) AndAlso Convert.ToDouble(row("Nettowert").ToString().Replace(",", ".")) < 600 
                             Select row).CopyToDataTable()
2 Likes
4

Your column is probably string, not float.

5

Assumption:
Value is string and using the German Number format: , is decimal Seperator

So we would convert the string by applying the german number format like this

The image shows a code snippet that parses a string ("12,50") into a double with German culture settings ("de-DE"), resulting in the value 12.5. (Captioned by AI)
The image shows a code snippet that parses a string ("12,50") into a double with German culture settings ("de-DE"), resulting in the value 12.5. (Captioned by AI)595×337 12.3 KB

and can incorporate it within the following LINQ:
Assign Activity:
dtFiltered | DataType: DataTable =

(From d in YourDataTableVar.AsEnumerable
Let vs = d("Nettowert").toString.Trim
Let vp = Double.Parse(vs , System.Globalization.CultureInfo.CreateSpecificCulture("de-DE"))
Where vp < 600
Select r = d).CopyToDataTable

Handling empty filterresult:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

Starter Help for LINQ:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

Kindly note:
weil von kleiner 600 die Rede war, haben wir die Bedingung Where vp < 600 gewählt
In den Screenshots war aber das Entfernen der Zeilen von < 600 gewählt
ggf. muss das Filterkriterum angepasst werden, mit einem > 600 oder einem Not, um es zu verneinen

1 Like
6

Hi guys, thank you all for the input. You were defintly right. The issue was the formating with the german thausands seperator.

I have found an easy solution in UI Path. You can define how the numbers should be read.

The image shows the "Tabellenextraktion" (Table Extraction) dialog in UiPath with settings for extracting data, including column settings for "Nettowert" that define how to analyze, sort, and format numerical data. (Beschriftet durch KI)
The image shows the "Tabellenextraktion" (Table Extraction) dialog in UiPath with settings for extracting data, including column settings for "Nettowert" that define how to analyze, sort, and format numerical data. (Beschriftet durch KI)696×651 25.8 KB

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.