Binning On Unique Values
I have a dataset that contains order details and salesperson assignments, along with a split %. I need to assign each transaction a unique ID. I used to accomplish this in Alteryx with the ‘Tile’ tool. Essentially I need to check for all columns besides the salesperson ID / split %, and if all the other columns match another row, both (or multiple) rows get the same ID number. Any ideas?
| Order | Amount | Salesperson ID | Split % | Bin / Unique ID |
| A | 500 | 123 | 100 | 1 |
| A | 750 | 123 | 50 | 2 |
| A | 750 | 456 | 50 | 2 |
| B | 500 | 456 | 75 | 3 |
| B | 500 | 789 | 25 | 3 |