Sadly, I have no control over the source CSVs - they are from a backup zip file.
I’m trying to denormalise the key data down to the most detailed level in LiveCode to simplify a single import into Excel - to enable pivot table reporting without having to reconstruct the relationships in Excel using Vlookups. Best, Keith.. > On 15 Mar 2015, at 15:14, Peter Haworth <[email protected]> wrote: > > Are you creating the csv file yourself? If so, it should be easy to use a > Select statement with JOINs to make one row for each group of related > entries from the four tables. > > On Sun, Mar 15, 2015, 6:59 AM Keith Clarke <[email protected]> wrote: > >> Thanks for the steer, Mike. I’ve not really used arrays before, but this >> sounds a more efficient approach - so I’ll wok through the lessons & docs. >> Best, >> Keith.. >> >>> On 15 Mar 2015, at 13:21, Mike Doub <[email protected]> wrote: >>> >>> Basically createa direct access to all the child tables. >>> >>> On Sunday, March 15, 2015, Mike Doub <[email protected]> wrote: >>> >>>> Would it not be better to make the child table into an array indexed by >>>> its ID, then make a single pass thru the parent table using the child ID >>>> into the array. >>>> >>>> Mike >>>> >>>> On Sunday, March 15, 2015, Keith Clarke <[email protected] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>>> >>>>> Folks, >>>>> Is there a ‘smart’ way to denormalise ‘child' & ‘parent' CSV tables >>>>> extracted from an RDBMS in LiveCode or is it down to iterating through >>>>> lists using chunk functions? >>>>> >>>>> I have four tables, related in the database as >>>>> Child-Parent-GrandParent-GreatGrandParent. Each file has its own >> record ID >>>>> & the ID of its direct parent. I need to create a ‘DenormalisedChild' >> file >>>>> with GrandParent & GreatGrandParent IDs appended to each row. >>>>> >>>>> I’m currently assuming the only way forward is to build a >>>>> tDenormalisedChild variable by repeated iteration at each ‘level’: >>>>> Iterating through lines of the Child file to compare its ChildParentId >>>>> with each row in the the Parent file, until ParentRowId = >> ChildParentId; >>>>> Repeat (1) on Parent file rows to find ParentGrandParent values; >>>>> Repeat (1) on GrandParent file rows to get GreatGrandParent values >>>>> >>>>> Is their a more efficient approach? >>>>> Best, >>>>> Keith.. >>>>> _______________________________________________ >>>>> 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 >> >> >> _______________________________________________ >> 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 _______________________________________________ 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
