Hi team,
I want to filter to retailers from my “Customer Name” columns while I want to keep just one filtering condition for other columns-- Here is the current
Expression for my filter
dt_DataSource.AsEnumerable.where(function(x) x(“Customer Name”).ToString.Equals(“PACIFIC SUNWEAR OF CALIFORNIA” ) 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(“dd/MM/yyyy”).Equals(“01/04/2023”)).CopyToDataTable
I want to filter “PACIFIC SUNWEAR OF CALIFORNIA” and “CALISUN” from the “Customer Name” while the filter condition for other columns remain the same as you see in the above.
Thanks a lot!