2 Replies Latest reply: Jun 2, 2017 2:23 AM by Sergey Shuklin RSS

    Why is resident load not working?

    Markus König

      I have the following Code:

       

      Table1:
      Load * inline
      [
      UK, A
      1,Q1
      2,Q1
      3,Q1
      4,Q2
      5,Q2
      6,Q2
      7,Q3
      8,Q3
      9,Q3
      10,Q4
      11,Q4
      12,Q4
      ];
      
      Left join (Table1)
      Load * inline
      [
      UK, B
      1,1
      2,1
      3,1
      4,1
      5,1
      ];
      
      Final_table: 
      Load 
      UK,
      A,
      if(B=1,1,0) as B
      resident Table1;
      
      drop Tables Table1;
      
      
      
      
      

       

      If I run the script. I end vwith no tables. Goal is to have the Final_table. What is my error?