Hi fellow Alteryx community member,
Need to pick on your brains to solve this:
LOAD ID is the intended output
Please let me know if you needed further clarification 😀
thank you
| | | | | | OUTPUT |
| VENDOR | VENDOR SUBGROUP | LOAD # ASSIGNMENT | LOAD COUNT BY VENDOR SUBGROUP | Sum_LOAD COUNT BY VENDOR | LOAD ID |
| 921338 | - | 1 | 1 | 1 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 1 | 3 | 8 | 1 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 2 | 3 | 8 | 2 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | 98304 | 3 | 3 | 8 | 3 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | - | 1 | 1 | 8 | 4 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 1 | 4 | 8 | 5 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 2 | 4 | 8 | 6 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 3 | 4 | 8 | 7 |
| 96733 | 98305 | 4 | 4 | 8 | 8 |
| 96733 | 98305 | 4 | 4 | 8 | 8 |
| 921338 | - | 1 | 1 | 1 | 1 |
