I need some help with the Linq datatable filtering. I am struggling with step 2 Linq coding which I couldn’t find a similar scenario in the forum.
Below are the steps:
- I have the code to filter DT2 where the “Robot Use” column is not empty then I will be left with Row 2 & 3 in DT2.
DT2.AsEnumerable.Where(Function (row) Not String.IsNullOrEmpty(row(“Robot use”).tostring)).copytodatatable()
Filter DT1 Vendor and Document Currency with DT2 Vendor and Document Currency then I should get something on the “Final DT1 result” (refer to image)
Then I will need the Document Number and Amount in doc curr for other purposes.
Thank you in advance.