Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

christina_muell
New Contributor

Concatenate two colums

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Concatenate two colums

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);

3 Replies
MVP
MVP

Re: Concatenate two colums

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);

christina_muell
New Contributor

Re: Concatenate two colums

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);

MVP
MVP

Re: Concatenate two colums

Super

Community Browser