How to select rows which contains data more than 2 columns

[Ishan_Shelke]

I have data like this

Now What I want to do is select only those rows who contain more than 2 column data in it

So here My output should be :

Since Row No 2 and 3 have only 2 and 1 column data respectively they are ignored

[Nithinkrishna]

Hey @Ishan_Shelke

Kindly try the below,

dt_Data.AsEnumerable.Where(Function(row) row.ItemArray.Count(Function(item) not String.IsNullOrEmpty(Convert.ToString(item))) >= 2).CopyToDataTable

Thanks
#nK

[THIRU_NANI (NaNi)]

Hey!

Try like this

Use filter data table to achieve this

See the attached screenshot!

Provide the Third column

Regards,
NaNi