LINQ Query:
Non-Matched Values :
dtMonthlyTable.AsEnumerable().Where(Function(row) Not dtReferenceTable.AsEnumerable.Any(Function(x) x(“Item Name”).ToString=row(“Item Description”).ToString)).copytoDataTable
Length and where:
dtMonthlyTable.AsEnumerable().Where(Function(row) row("Item Description").ToString.Length = 4).CopyToDataTable
Multiple Where:
dtMonthlyTable.AsEnumerable().Where(Function(row) row("Item Description").ToString.Length = 4).Where(Function(row) row("Quantity").ToString.Contains("3")).CopyToDataTable
On this page of the site you can watch the video online Where function to Get Not Matching values,Length,Multiple where Functions- Linq query UiPath-Part 3 with a duration of hours minute second in good quality, which was uploaded by the user Harika Mudiam 31 January 2022, share the link with friends and acquaintances, this video has already been watched 2,476 times on youtube and it was liked by 46 viewers. Enjoy your viewing!