Create buckets using sequence number

[markgraham123]

Hi all,

Help please.

I'm trying to create 8 or 16 buckets in my dataset. 

Looking at my sequence number, i should create buckets grouped by pair.

I can only be either 8 or 16 orders. If i cannot make up to 16 orders, i try to make 8 orders. Remaining go into bucket '99999'. If no 8 buckets can be made, all in that pair goes to '99999' Here is my sample data. 

Please see attached for qvw. Please help!

Below is the data sample:

Order	SKU	Pair	Seq. Num	Bucket by Pair
121118463	100234	2	1	1
158856565	99358	2	2	1
158856565	105266	2	2	1
159061651	67970	2	3	1
159061651	67972	2	3	1
159061651	86240	2	3	1
159080104	67972	2	4	1
159080104	99641	2	4	1
159080104	151281	2	4	1
159081551	93819	2	5	1
159097798	114205	2	6	1
159109358	76322	2	7	1
159109358	76324	2	7	1
159109358	76342	2	7	1
159129901	61810	2	8	1
159130517	76207	2	9	99999

[markgraham123]

@rwunderlich @marcus_sommer @sunny_talwar  Any of your help is highly appreciated 🙂

[sunny_talwar · Accepted solution]

Just responded here

Create a sequence number and create buckets