Need to compare two datagrids

Magicgate Software - Skip Kimpel skip at magicgate.com
Mon May 5 15:52:25 EDT 2014


I have two datagrids that I need to compare column 1.  I then need to
separate these two lists out into additional datagrids.

For instance, datagrid 1 contains three columns:
1234, ItemA, ItemDetails
1235, ItemB, ItemDetails
1236, ItemC, ItemDetails

Datagrid 2 contains three columns:
1234, ItemA, ItemDetails
1235, ItemB, ItemDetails

After the comparison I need a DG that has similar items and a separate DG
that has unique items:
Datagrid 3 would result in: (same items)
1234, ItemA, ItemDetails
1235, ItemB, ItemDetails

Datagrid 4 would result in: (unique items)
1236, ItemC, ItemDetails

My head is spinning in datagrid code!  Any help would be greatly
appreciated!

SKIP



More information about the use-livecode mailing list