Hi, I have a challenge, the report contains orders with a value Rate > 47. However, there are also lines where this value is not available. In the result, I only want to have orders that do not have a line with a value > 47. How can I exclude the orders contained in DtExclude via Linq? DtExclude …

Hi, How about using DtExclude as the following? DtOutput = (From d In dtInput.AsEnumerable Where Not DtExclude.AsEnumerable.Any(Function(r) r("Order").ToString=d("Order").ToString) Where Convert.ToDateTime(d("Date").ToString) <= DateTime.Today Select d).CopyToDataTable And as @ashwin.ashok ment…

Linq how to exclude OrderID from a other Datatable

Help Studio

ashwin.ashok ((TheCodingTheory)) September 21, 2022, 7:17am 4

Hi @raiko.m ,

Could you please provide an example of the expected output?
I can help you from there.

Kind Regards,
Ashwin A.K

Topic		Replies	Views
Filter DataTable using Linq Studio studio , question , workflow_diff	14	4894	June 29, 2022
Datatable doubt Studio studio , question , workflow_diff	25	1675	June 11, 2022
Linq query to filter data table Studio question	6	2142	October 19, 2022
Filter DataTable for integer values only, using LINQ Help datatable	8	6526	February 6, 2020
Filter out based on date Studio studio , question , activities_panel	12	346	August 10, 2023

Linq how to exclude OrderID from a other Datatable

Related topics