10 Replies Latest reply: Dec 5, 2014 12:41 PM by Peter Rieper RSS

    How to merge 2 resident tables ?

    Laura Sébille

      Hi everyone,

       

      In my model, there are 2 tables which are linked on a common field.  I would like to merge them so I have only one table and then export it into qvd.

       

      I've tried this piece of code :

       

      MergeTable:

      LOAD *

      resident Table1;

       

      LEFT JOIN

       

      LOAD *

      resident Table2

      ;

       

      But it doesn't work, I still have the 2 tables in my model.

       

      What do I have to do ?

       

      Thanks