Concatenate two colums

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be this

Directory;

LOAD Function,

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

          Left([Account Number], 2) & '-' & Function as combination,

          Sales

FROM

P12.XLSX

(ooxml, embedded labels, table is Tabelle2);

[Anonymous]

This worked! Thank you

Directory;

LOAD Function,

          [Account Number],

          Left([Account Number], 2) & '-' & Function as combination,

          Sales

FROM

P12.XLSX

(ooxml, embedded labels, table is Tabelle2);

[sunny_talwar]

Super