topic Autonumber Based on Suffix in QlikView

Autonumber Based on Suffix

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

Is it possible to create an autonumber but based on the suffice's text format? They're different bec the designated field "NewMatcode" requires only 18 char or below . Thus, the suffix varies .

I tried to get the max based on the last subfield format like '0006' using below but did not work...

max(Num(SubField(Matcode, '-',-1),Repeat('0',Len(SubField(Matcode, '-',-1)))))

I also tried to generalized all suffix into 4 digits like 0006...but the problem is some items would exceed to18 char. Is there other ways that suffix will auto adjust based on 18 char?

Pls. see example below :

Pls. help.

Re: Autonumber Based on Suffix

luismadriz — Wed, 06 Dec 2017 06:38:04 GMT

Hi Caroline,

I don't think I understand your request, can you please write the MatCode as it comes and the NewMatCode as you would like to have it?

Cheers,

Luis

Re: Autonumber Based on Suffix

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:43:12 GMT

Why Last 2 rows showing 4 and 5 instead 2 and 5??

Re: Autonumber Based on Suffix

Anonymous — Wed, 06 Dec 2017 10:11:36 GMT

try this ...

Load AutoNumber(SubField(Matcode,'-',-2))&'-'& SubField(Matcode,'-',-1)as NewAutonumber,
Matcode;
Load * Inline [
Matcode
A1-10-357
A1-10-358
B1-20-400
B1-20-401
C1-30-500
C1-30-501
D1-40-600
];

Re: Autonumber Based on Suffix

Anonymous — Wed, 06 Dec 2017 16:21:37 GMT

hi! Anil,

If you look at B1-1009375-16-CY-1 and B1-1009375-16-CY-3...The max suffix is 3. Therefore, the next suffix number to be used would be 4 ..

Rgvds

Re: Autonumber Based on Suffix

Anil_Babu_Samineni — Fri, 08 Dec 2017 01:22:54 GMT

Clear, I am going to work now. Will you provide that excel ?