Where function to Get Not Matching values,Length,Multiple where Functions- Linq query UiPath-Part 3
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
![[친절한꿀팁] 다이소에서이것만은사지말자/다이소비추템](https://images.videosashka.com/watch/nlkaq6kQ83Q)
