LINQ - Filtering out empty rows

[Neal369]

Hello Friends,
I want to display non empty/non null rows based on column “country”.
I am getting error as shown in below screenshot,

LINQ :–>

(
From currentRow In DataTbl
Where Not currentRow(“Country”).ToString.IsNullOrEmpty
Select currentRow
).CopyToDatatable

May i know why i am getting this error? and how to resolve this error?

[ppr (Peter)]

(From d In DataTbl.AsEnumerable
Let chk isNothing(d(“Country”)) OrElse String.IsNullOrEmpty(d(“Country”).toString.Trim)
Where Not chk
Select r = d).CopyToDatatable

Handle empty filter result by:
[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

Also have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

[Suraj_B_Shetty (Suraj)]

Hi @Neal369

Try this

(
From currentRow In DataTbl.AsEnumerable
Where Not String.IsNullOrEmpty(currentRow(“Country”).ToString)
Select currentRow
).CopyToDatatable

Hope this helps

[arjunshenoy]

@Neal369

Alternate Approach:

dt.AsEnumerable.SkipWhile(Function(row) String.IsNullorEmpty(row(“country”).ToString)).CopyToDataTable

Hope this helps,
Best Regards.

[ppr (Peter)]

@arjunshenoy

Alternate Approach:

dt.AsEnumerable.SkipWhile(Function(row) String.IsNullorEmpty(row(“country”).ToString)).CopyToDataTable

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items …

We keep in Mind:

Col Value Sequence: A, B,C, NullOrEmptyString, E, F
SkipWhile will stop after C and not return E,F

[Neal369]

This is not working,
Giving below error -

[Anil_G (Anil Gorthi)]

@Neal369

I believe you copied the formula directly and pasted it…the error is becUse of the inverted comma…please remove it and re add it…that would solve the error

Cheers

[ppr (Peter)]

Always ensure or retype all Double Quotes as it has to be: " sometimes copy paste will cause this issue

[Neal369]

@Suraj_B_Shetty

This works perfect, thank you

[Neal369]

Correct, my apologies, thank you

[Neal369]

Working perfect,
Thank you