Solved: Re: Generate a sequence number from 1 to 7 - Qlik Community

9917mark · ‎2022-03-29

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 · ‎2022-03-29

LOAD sku,
     Mod(RowNo()-1,7)+1 as Seq
From YourSource

hope this helps

Marco

MarcoWedel · ‎2022-03-29

LOAD sku,
     Mod(RowNo()-1,7)+1 as Seq
From YourSource

hope this helps

Marco

9917mark · ‎2022-03-30

@MarcoWedel Thank you for you prompt response. Works perfectly

Generate a sequence number from 1 to 7