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

    Concatenate two colums

    Christina M�ller

      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.

      Directory;

      LOAD Function,

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

                 Accountnr & '-' & Function as combination,

                 Sales

      FROM

      P12.XLSX

      (ooxml, embedded labels, table is Tabelle2);

       

      Does somebody have an idea?

      Thank you - Tina