Generate a sequence number from 1 to 7

9917mark — Tue, 29 Mar 2022 17:53:11 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.

Re: Generate a sequence number from 1 to 7

MarcoWedel — Tue, 29 Mar 2022 19:10:22 GMT

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

hope this helps

Marco

9917mark — Wed, 30 Mar 2022 06:27:48 GMT

@MarcoWedel Thank you for you prompt response. Works perfectly