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

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.

Hi @Soundarya_Guduri

Try to Use If activity

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


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

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)