topic Concatenate Keys in QlikView

Concatenate Keys

Thu, 13 Feb 2014 08:42:20 GMT

hi i have an issue with concatenation of ordernummer and order row key.

Ordernr	RowNr	% Key
100	101	100101
1001	01	100101

i wish to set the length of the Order and the RowNr to 8 respective 5 places.

set len Ordernr = 8;

set len Rownr = 5;

then i wish to do an if statement to check the amount of the characters in the string and where there are missing places replaces with 0

ie. if(len(Ordernr < 8, fill replace(Ordernr,' ', 0) as Ordernr_tmp

and the same for RowNr if required.

i have attached a sample app if anyone has dealt with this before?

Best

Brad

Miguel_Angel_Baeyens — Thu, 13 Feb 2014 08:46:53 GMT

Hi Brad,

The easy way it comes to my mind is doing like this in the script:

LOAD

Text(Num(Ordernr, '00000000')) AS Ordernr // this will add leading zeroes as needed up to 8 figures total

Miguel

Thu, 13 Feb 2014 09:11:52 GMT

Hi Bradley

an other way is to concatenate like this, and autonumber your key

autonumber(OrderNr & '-' & Rownr)

you'll get 100-101 transformed as number %Key = 1

and 1001-01 transformed as number %Key = 2

best regards

Chris