9 Replies Latest reply: Apr 14, 2016 6:47 AM by Gysbert Wassenaar RSS

    Load  different files and join. Difference betwean concatenate and not?

    Markus König

      Hi i have the following code:

      Table_1:
      LOAD
      Attribute_A,
      Attribute_B
      FROM X.qvd (qvd);
      
      left join Table_2:
      Load 
      Attribute_B, 
      Attribute_C
      FROM Y1.qvd (qvd);
      
      Load 
      Attribute_B,
      Attribute_C
      FROM Y2.qvd (qvd);
      
      Load 
      Attribute_B, 
      Attribute_C
      FROM Y3.qvd (qvd);
      
      
      
      
      

       

      If I use this code i have a Table_2 in the Data_Structure. If I use Concatenate:

       

      Table_1:
      LOAD
      Attribute_A,
      Attribute_B
      FROM X.qvd (qvd);
      
      left join Table_2:
      Load 
      Attribute_B, 
      Attribute_C
      FROM Y1.qvd (qvd);
      Concatenate
      Load 
      Attribute_B,
      Attribute_C
      FROM Y2.qvd (qvd);
      Concatenate 
      Load 
      Attribute_B, 
      Attribute_C
      FROM Y3.qvd (qvd);
      
      
      

       

      I don't have Table_2 is not in the Data_Structure.

      I thought both codes should deliver the same result. Is it because of the join that QlikView uses the joins after the first tables and ignore the other 2 tables?