Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;
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
Hello Nakul,
yes, That's the case, i would like to know if exist some function to do this sequence.
Thanks
Hello Sunny,
i don't understand the Autonumber, how can i use it?
Thanks
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;
Look at the sample I provided below
Thanks Sunny, i get it!