14 Replies Latest reply: Sep 13, 2013 12:29 PM by Wallace Fan RSS

    Concatenate two tables and just replacing a specified column

      Hello Experts,

       

      I am starting to learn concatenate function in Qlikview and I want to replace column f2 from table 2 into table 1

      so the intended result as the following table:

       

      f1f2f3
      aac4
      bbc5
      cbc6
      dbc2
      ecc3

       

      table2:

      f1f2f3
      aac1
      dbc2
      ecc3

       

      table1:

      f1f2f3
      abc4
      bbc5
      cb

      c6

       

       

      I used the code below and the result table turn out to be this:

      f1f2f3
      aac1
      abc4
      bbc5
      cbc6
      dbc2
      ecc3

       

       

      LOAD f1,

           f2,

           f3

      FROM

      C:\table1.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

      Concatenate

       

      LOAD f1,

           f2,

           f3

      FROM

      C:\table2.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

       

      PLEASE HELP!!! THANKS IN ADVANCE!!