Kindly note the referenced case is less complex as it checks only for one Value without any concatenations (Name Cols) and multiple Cols (Name, Adress). Also it has the potential to reduce it with an Any Statement. Also it is not updating any columns in a table
In real scenario we also have the risk that the Name split will increase the complexity on additional.
However task can be solved on:
- Join Approach
- Filter Approach
For the Join Approach the Join Data Table is a good start
- left join dtData TO dtMain
- Selecting the result can be done with a LINQ, Also resorting the cols on AccNo INTs in the same statement
Find Demo XAML here:
iVishalNayak_JA-Approach.xaml (11.9 KB)
For the Filter Approach
- for the check we can rely close to this what was done above in the filter LINQ
Find Demo here:
iVishalNayak_LINQ-Approach.xaml (10.8 KB)
For fast Prototyping both will work fine. For Production use it is more recommended to find some balanced approache by combining different buuilding blocks (For Each, Join, Filter…) to enforce the possibilty to maintain and to track.