6 Replies Latest reply: May 16, 2018 5:41 AM by Youssef Belloum RSS

    After concatenating not able to retrieve data from table 2

    Ranajit Sircar

      Hi

       

      I have two table. Table 1 & Table B 2 am fetching the data from SQL database. While I do a concatenation data from table 2 is not retrieving. I am doing this in Qliksense.

       

      Below is my script.

       

      Table A

      Load

      A,

      B,

      C;

      Sql Select

      A,

      B,

      C

      From Table 1

       

      Concatenate  (Table A)

      Load

      A,

      B,

      C;

      Sql Select

      A,

      B,

      C

      From Table 2

       

      Qualify*;

        Unqualify "B";

        Table A_New: 

        Load *

        Resident Table A;

        Drop Table Table A;

       

      Both the table 1 & table2 has same column name.