Denormalising CSV tables

Mike Doub mikedoub at gmail.com
Sun Mar 15 08:49:59 EDT 2015


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



More information about the use-livecode mailing list