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