This content has been marked as final. Show 3 replies
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