Remove rows with specific words from datatable

Help Activities
, ,
15

@Sudharsan_Ka

I tried the following, but poorly it is not working. Do you have an idea?

dT1.AsEnumerable().Where(Function(s) Not fiscalYear +" “+ “1Q”,fiscalYear +” “+ “2Q”,fiscalYear +” “+ “3Q”,fiscalYear +” "+ “4Q” .Contains(s(“Fiscal Year”).ToString)).CopyToDataTable

dT1.AsEnumerable().Where(Function(s) Not (fiscalYear +" “+ “1Q”,fiscalYear +” “+ “2Q”,fiscalYear +” “+ “3Q”,fiscalYear +” "+ “4Q”) .Contains(s(“Fiscal Year”).ToString)).CopyToDataTable