Special sequence in straight table?

[olramirez]

Hello,

could help me with this special sequence in Straight table please?

The order is by Botiquin, Fecha de Emisión and Documento, but the Sequence should repeat when the Documento column is the same.

Special Sequence	BOTIQUIN	FECHA DE EMISION	DOCUMENTO
1	CUAUHTEMOC METRO FARMA	04/04/2016	ER16-9994
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
3	CUAUHTEMOC METRO FARMA	22/04/2016	CR16-9169
4	CUAUHTEMOC METRO FARMA	24/04/2016	CR16-9182
4	CUAUHTEMOC METRO FARMA	24/04/2016	CR16-9182
5	CUAUHTEMOC METRO FARMA	25/04/2016	036600
5	CUAUHTEMOC METRO FARMA	25/04/2016	036600
6	CUAUHTEMOC METRO FARMA	25/04/2016	085133
7	CUAUHTEMOC METRO FARMA	25/04/2016	085139
8	CUAUHTEMOC METRO FARMA	25/04/2016	087533
9	CUAUHTEMOC METRO FARMA	25/04/2016	165969
10	CUAUHTEMOC METRO FARMA	25/04/2016	166000
10	CUAUHTEMOC METRO FARMA	25/04/2016	166000
11	TICOMAN	02/04/2016	207963
12	TICOMAN	13/04/2016	206474
13	TICOMAN	13/04/2016	206477
13	TICOMAN	13/04/2016	206477
14	TICOMAN	25/04/2016	206478
15	TICOMAN	25/04/2016	206487
15	TICOMAN	25/04/2016	206487

[Anonymous]

Hi Olga,

Not sure if I follow the query here. You want a same number to appear in column Special Sequence for the matching values in DOCUMENTO column right? In your screenshot I think that is already the case, no?

Tx

Nakul

[olramirez]

Hello Nakul,

yes, That's the case, i would like to know if exist some function to do this sequence.

Thanks

[olramirez]

Hello Sunny,

i don't understand the Autonumber, how can i use it?

Thanks

[sunny_talwar · Accepted solution]

Something like this?

Table:

LOAD RowNo() as UniqueKey,

  BOTIQUIN,

    [FECHA DE EMISION],

    DOCUMENTO

FROM

[https://community.qlik.com/thread/214642]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

LOAD *,

  AutoNumber(BOTIQUIN&[FECHA DE EMISION]&DOCUMENTO) as SpecialSequence

Resident Table

Order By BOTIQUIN, [FECHA DE EMISION], DOCUMENTO;

DROP Table Table;

[sunny_talwar]

Look at the sample I provided below

[olramirez]

Thanks Sunny, i get it!