Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@rwunderlich @marcus_sommer @sunny_talwar Any of your help is highly appreciated 🙂
Just responded here