3 Replies Latest reply: Nov 6, 2014 1:22 AM by Ashfaq Mohammed RSS

    Join(Table1) in Script

    Gopi Raju

      Hi All,

      I am unable to undertsand JOIN mentioned in Qlikview help point I.

      Please help to explain with the two tables shown in point II.

      Thanks in advance.

      I)
      tab1:

      LOAD * FROM file1.csv;

      tab2:

      LOAD * FROM file2.csv;

      .. .. ..

      join (tab1) LOAD * FROM file3.csv;

      II)
      Table1:
      Load * inline
      [
      A,B
      1,aa
      2,bb
      3,cc
      4,dd
      ]
      ;

      Join(Table1)

      Table2:
      Load * inline
      [
      A,C
      1,xx
      2,yy
      5,tt
      ]
      ;