Filter Data Table does not work

Help Solution Accelerators
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