7 Replies Latest reply: Oct 9, 2013 10:19 AM by Antoine Frangieh RSS

    Temp table not dropping (Temp-1)

    Antoine Frangieh

      Hello,

       

      I am facing a weird phenomena.

      Assume this scenario:

       

      Script 1:

      Temp:

      Load * Inline [

      A,

      x,

      ];

       

      T1:

      Load * Inline [

      A, C,

      x, z,

      y,k,

      x, b,

      ];

       

      Right Keep ('T1')

      Load

      *

      Resident Temp;

      Drop Table Temp;

       

      The Output: T1 linked to Temp-1with T1 reduced in content to only x values.

       

      Script 2

      Temp:

      Load * Inline [

      A,

      x,

      ];

       

      T1:

      Load * Inline [

      A, C,

      x, z,

      y,k,

      x, b,

      ];

       

      Right Keep ('T1')

      Temp1:

      Load

      *

      Resident Temp;

      Drop Tables Temp, Temp1;

       

      The Output: T1 with T1 reduced in content to only x values.

       

      Usually this doens't happen with me(or I don't notice it:) ),  so can anyone share his insight?


      Thanks,


      Antoine