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

    Order of operations in data load script

    Jonathan Vitale



      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)


      Load FRUITS, VEGETABLES from ...



      Load FRUITS, VEGETABLES from ...


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


      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).