Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All -
I have a spreadsheet with more than thousand records. Need to assign one number for every 6 records.
For instance:
----------
----------
Thank you.
LOAD
*
Div(RecNo()+5, 6) as ID
FROM ...
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Is you data always a new IDnumber every 6 numbers?
LOAD
*
Div(RecNo()+5, 6) as ID
FROM ...
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Thank you.