Discussion Board for collaboration on QlikView Scripting.
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.
Left([Account Number], 2)as Accountnr.,
Accountnr & '-' & Function as combination,
(ooxml, embedded labels, table is Tabelle2);
Does somebody have an idea?
Thank you - Tina
Go to Solution.
May be this
Left([Account Number], 2) as Accountnr.,
Left([Account Number], 2) & '-' & Function as combination,
This worked! Thank you