Solved: Assign one number for every 6 records - Qlik Community

nihhalmca · ‎2022-07-08

Hi All -

I have a spreadsheet with more than thousand records. Need to assign one number for every 6 records.

For instance:

----------

Thank you.

rwunderlich · ‎2022-07-08

LOAD
*
Div(RecNo()+5, 6) as ID
FROM ...

JHuis · ‎2022-07-08

Is you data always a new IDnumber every 6 numbers?

rwunderlich · ‎2022-07-08

LOAD
*
Div(RecNo()+5, 6) as ID
FROM ...

nihhalmca · ‎2022-07-11

Thank you.

Assign one number for every 6 records