Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Assign one number for every 6 records

Hi All - 

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

For instance:

nihhalmca_0-1657275451835.png

----------

----------

Thank you.

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

3 Replies
JHuis
Creator III
Creator III

Is you data always a new IDnumber every 6 numbers?

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

nihhalmca
Specialist II
Specialist II
Author

Thank you.