11 Replies Latest reply: Feb 1, 2016 3:41 AM by reshma paturi RSS

    script to join/merge table in the data model viewer. need help :(

    Teck Rul Saw

      Hi there  Qlikers, anyone knows how to from this

       

      to this (below) ?

       

       

       

      1st scenario load script is :

      table1:

      LOAD

          Column1,

          Column2

      FROM [lib://testConnection (rsmain2_administrator)/testDATA.txt]

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

      table2:

      LOAD

          Column1,

          Column3

      FROM [lib://testConnection (rsmain2_administrator)/testData2.txt]

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

      2nd scenario load script is :

       

      table1:

      LOAD

          Column1,

          Column2

      FROM [lib://testConnection (rsmain2_administrator)/testDATA.txt]

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

      inner join

      LOAD

          Column1,

          Column3

      FROM [lib://testConnection (rsmain2_administrator)/testData2.txt]

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

       

       

       

       

      I have tried:

       

      table3:

      load Column1, Column2 Resident table1;

      inner join

      load Column1, Column3 Resident table2;

       

      drop table table1;

      drop table table2;

       

       

       

      But it results in "NO DATA LOADED". Any knows how?