topic Re: Concatenate two colums in QlikView

Concatenate two colums

Anonymous — Wed, 08 Nov 2017 13:24:59 GMT

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 — Wed, 08 Nov 2017 13:37:28 GMT

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 — Wed, 08 Nov 2017 13:48:59 GMT

This worked! Thank you