7 Replies Latest reply: Mar 3, 2018 10:52 AM by THIAGO TEIXEIRA RSS

    Concatenate resident table

    Michael Simonsen

      Hi!

       

      In my load script I want to concatenate a previously loaded table to my one fact table. The scripts principle goes like this:


      FACT:

      Load *

      From table1 ;


      Concatenate FACT:

      Load *

      From table2;


      Concatenate FACT:

      Load *

      From table3;


      // Now I need to first load table4 without concatenation, and make some calculations i table4

      NoConcatenate

      Table4:

      Load *

      From table4;

       

      At the end I now want to include Table4 in my FACT.

      I have tried:

       

      Concatenate FACT:

      Load *

      Resident Table4 ;

      Drop Table Table4;

       

      But it does not work. I lose all variables from table4

      Any ideas?

       

      Regards Michael