3 Replies Latest reply: Nov 8, 2017 8:51 AM by Sunny Talwar RSS

    Concatenate two colums

    Christina mueller

      Hey QlikView community,


      I have a question to combine two columns of an excel sheet.


      1. I want to take only the left two numbers out of the colum "account number".

      2. I want to combine this first two numbers of Accountnr with the column Function.


      This was my first try, but it says, that the field accountnr doesn't exist.


      LOAD Function,

                 Left([Account Number], 2)as Accountnr.,

                 Accountnr & '-' & Function as combination,




      (ooxml, embedded labels, table is Tabelle2);


      Does somebody have an idea?

      Thank you - Tina