Is there any LINQ for skipping an empty column value in a datatable?

[Soundarya_Guduri]

In datatable there are few empty cells
The requirement is how to skip the columns having empty or null cell value. Is there any query to do this.

[Gokul001 (Gokul Balaji)]

Hi @Soundarya_Guduri

Try to Use If activity

isNothing(row(YourColNameOrIndex)) OrElse String.IsNullOrEmpty(row(YourColNameOrIndex).toString.Trim)

Regards
Gokul

[ppr (Peter)]

@Soundarya_Guduri

The requirement is how to skip the columns having empty or null cell value. Is there any query to do this.

it is depending on your retrieval strategy:
cols per row
1 col over all rows
…

the best would be to share with sample input and output

[Anil_G]

Hi @Soundarya_Guduri

You can do that like this

this is the condition in if

CurrentRow.ItemArray.Contains(String.Empty) Or CurrentRow.ItemArray.Contains(Nothing)