4 Replies Latest reply: Dec 18, 2017 12:37 PM by Jonathan Vitale RSS

    Order of operations in data load script

    Jonathan Vitale

      Hello,

       

      This feels pretty beginner, but I'm not sure what the answer is, so please let me know. If I have script like the following:


      Left Join (TableA)

      TableB:

      Load FRUITS, VEGETABLES from ...

       

      TableC:

      Load FRUITS, VEGETABLES from ...

       

      Will table B first join to table A, and then a separate table C will load into memory

      OR

      Will table B and C concatenate and then the result will be joined with TableA

      ?

       

      In this case I would prefer that the concatenation occurs before the joining, but I suspect that it wouldn't.

       

      (by the way, I can do a workaround with Residents - no problem - I just want to make sure I understand how the order of operations works in script loads).