Denormalising CSV tables

[Keith Clarke]

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 <mikedoub at gmail.com> wrote:
> 
> Basically createa direct access to all the child tables.
> 
> On Sunday, March 15, 2015, Mike Doub <mikedoub at gmail.com> 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 <keith.clarke at me.com
>> <javascript:_e(%7B%7D,'cvml','keith.clarke at me.com');>> 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
>>> 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
>> 
>> 
> _______________________________________________
> 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