3 Replies Latest reply: Dec 12, 2017 5:16 PM by ashok zubrewar RSS

    Qlik sense joins Question

    ashok zubrewar

      Hi,

       

      I am new to qlik. I am trying to follow document and practice joins in qlik sense (In general I understand how joins work in DB).

       

      Attached are the screenshots of qlik sense example and error.

       

      I am loading data from excel as Table1 and Table2 then within Qlik sense i am trying to create another table called Vtable to store join result. Please let me know what i am doing wrong.

       

      Table1 Data

      A,B

      1,aa

      2,cc

      3,ee

       

      Table2 Data

      A,C

      1,xx

      4,yy

       

      Qlik Sense Script:

       

      Table1:

      LOAD

          A,

          "B"

      FROM [lib://QS_Practice/Joins\Joins.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      Table2:

      LOAD

          A,

          C

      FROM [lib://QS_Practice/Joins\Joins.xlsx]

      (ooxml, embedded labels, table is Sheet2);

       

      VTable:

      load * from Table1;

      inner join Load * from Table2;

        • Re: Qlik sense joins Question
          Luis Madriz

          Hi Ashok,

           

          Please use the following:

          VTable:

          NoConcatenate

          load * Resident Table1;

          inner join Load * Resident Table2;

           

          Drop Tables Table1,Table2;

           

          I hope this helps,

           

          Regards,

           

          Luis

            • Re: Qlik sense joins Question
              Luis Madriz

              In order to use the Select statements as it says on the Tutorial, you need to open a connection and then refer to a table in that connection using the select statements.

               

              If the tables have already been loaded in memory then you use resident to refer to them

               

              Qlik will automatically concatenate tables that look the same and as Table1 and VTable look the same, you need to explicitly say not to concatenate.

               

              The deletion of the tables at the end is for them not to link.

               

              You should play with all these by placing those instructions as comments and see the difference,

               

              I hope this helps,

               

              Cheers,

               

              Luis

            • Re: Qlik sense joins Question
              ashok zubrewar

              Luis,

               

              Thank you.i got it now. i think i was doing 2 things wrong.

               

              1. i was trying as is without realizing example refereed to DB tables

              2. I was using resident but Noconcatenate, Vtable wasn't created.

               

              I knew all of this theoretically but i was n't able to do practical. Thank you for your help!.