topic Allocate a sequence number from 1 to 7 in App Development

Allocate a sequence number from 1 to 7

9917mark — Tue, 29 Mar 2022 17:43:28 GMT

Evening,

I have a requirement to allocate a sequence number to my data from 1 to 7.

This must then repeat from 1 to 7 until the table has finished loading.

Table consists of a list of SKU's totaling 87000

The Idea is to use the sequence number to filter the data for easier analysis.

And then export each sequence number to an excel spreadsheet for import.

Sample Raw Data:

Desired Result:

Thank you in advance.

MarcoWedel — Tue, 29 Mar 2022 19:16:03 GMT

QFabian — Tue, 29 Mar 2022 19:18:37 GMT

Hi @9917mark , here an example, please check if works for you :

Aux:
LOAD * INLINE [
sku
1000000
1000001
1000003
1000004
1000005
1000006
1000007
1000008
1000009
1000010
1000011
1000012
1000014
1000015
1000016
];

SKU:
Load
rowno() as Idf,
sku,
if(rowno() = 1 or peek(Seven) = 7, 1, peek(Seven) + 1) as Seven
Resident Aux;
drop table Aux,

OUTPUT :