Perfect
Just have a final look on the 3 different approaches
Gokul’s Approach:
- it is reflecting a nested loop where in inner loop all rows are checked
- when more then 1 rows are found within the where block then the where check is matching
- current loop rows will be forwarded
- with the nested loop approach we have n rows * n rows (when not reduced by the where) touches
Ashwins Approach:
- Group By within Method syntax
ppr Approach
- group by within Query Syntax + plus Ordering on the origin datarow position
For entering more the LINQ topics have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum