How to get other matched value in a separate column in a Datatable? Please Help

@GuhanTM
find attached demo xaml:
SelfJoin_1Col.xaml (7.9 KB)
grafik

grafik
Have a look on following to track the nature of Join:
F 300 does not find a join pair, so it is ommited
A 100 can also join with itself, so it was necessaire to filter out d1(0) = d2(0)
the 200 group with 3 members is joining all members so pairs are found for #1-#2, #1-#3

Let us know your feedback

1 Like