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 |
