Comments by Chris Smith Jul2021 (Top 1 by date)

Chris Smith Jul2021 20-Jul-21 13:23pm View

Ah and this is where I'm getting stuck..I cant order the 2 sets of items because the lists contain different values..

So list 1 may have
1,aaa,Bbb
2,ccc,ddd
3,eee,fff

Where as list 2 would have
2,ccc,ddd
8,xxx,ZZZ

(The only common data in the example above is number 2)

So if I order them there not in sync and don't match as list 2 will have values not present in list 1..

This is what I'm struggling with..
In the example above I need to loop through list 1, check if the data row exists in list 2 (compare by the first data field/value - so the '2' in this case) and if so compare the other data fields in that row..

Ha its definitely not a homework assignment, not at my age, but I am just starting out on my dev journey..

Happy just to get some pointers as to how do this..