Remove values with 0 in the columns using Linq queries

Help Activities
, ,
1

Hi Team

Attaching input file
BankInputFile.xlsx (10.7 KB)

I want to remove rows with values 0 in Countries column using linq queries.

Please do it using Linq Queries

Output Should be
Output.xlsx (10.7 KB)

Thanks
Likitha

2

Hey @vinjam_likitha
try this:
dtFiltered = dtInput.AsEnumerable().Where(Function(row) Not row("YourCountry").ToString.Equals("0")).CopyToDataTable()

3

Hi @vinjam_likitha

Try this

(From row In inputDataTable.AsEnumerable()
                   Where row.Field(Of Integer)("India") <> 0
                   Select row).CopyToDataTable()
4

Hi @vinjam_likitha

Check out the below zip file

BlankProcess26.zip (63.2 KB)

Hope this meets your requirement

Output.xlsx is the final Output.

Regards