How to Filter Two or More Items from a columns in Datatable

[Sisay_Dinku]

Sample_Data.xlsx (15.3 KB)
@Suraj_B_Shetty see this attachment.

[Sisay_Dinku]

@Suraj_B_Shetty ignore CALISUN and use the ones you see in the sample data. Thanks!

[Suraj_B_Shetty (Suraj)]

Hi @Sisay_Dinku

In the sample file which u shared, only “PACIFIC SUNWEAR OF CALIFORNIA” has line items with start date “01/04/2023”. Thats why you are able to see only that line item. Modify the input and verify with the same code.

Hope this helps

[Sisay_Dinku]

@Suraj_B_Shetty Thank you so much. That’s a silly mistake. If I have to make it the whole month of April, how do I do that in the date part? Thanks!

[Suraj_B_Shetty (Suraj)]

@Sisay_Dinku

Give a try to this

dt_input.AsEnumerable.where(function(x) (x(“Customer Name”).ToString.Equals(“PACIFIC SUNWEAR OF CALIFORNIA”) Or x(“Customer Name”).ToString.Equals(“CALISUN”)) And x(“Warehouse Id”).ToString.Equals(“09”) Andalso DateTime.parseExact(x(“Start Dt”).ToString,“MM/dd/yyyy 00:00:00”,system.Globalization.CultureInfo.InvariantCulture).ToString(“MM”).Equals(“04”)).CopyToDataTable

Or

dt_input.AsEnumerable.where(function(x) (x(“Customer Name”).ToString.Equals(“PACIFIC SUNWEAR OF CALIFORNIA”) Or x(“Customer Name”).ToString.Equals(“CALISUN”)) And x(“Warehouse Id”).ToString.Equals(“09”) Andalso DateTime.parseExact(x(“Start Dt”).ToString,“MM/dd/yyyy 00:00:00”,system.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM”).Equals(“April”)).CopyToDataTable

Hope this helps.

[Sisay_Dinku]

@Suraj_B_Shetty Much appreciation. That worked perfectly fine. Thank you so much!!