Need to compare two datagrids

[Bob Sneidar]

Easier to work with SQL. Dump your data into two memory resident sqLITE databases and use SQL for your comparisons. I did mention quite a while ago how nice it would have been to get a single column of data from a data grid. But it would not be too difficult to get into the library and write the functionality into it yourself. 

Bob


On May 5, 2014, at 12:52 , Magicgate Software - Skip Kimpel <skip at magicgate.com> wrote:

> 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
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode