I have need to produce column R in a dataset that only has the first 3 columns. I need a running count of distinct records of studentid, feeid, and transactionid. The first one is 1, second is 2, etc.
This is easy in Oracle (in fact, the other half of this dataset is coming from Oracle), but it is MySQL. That means I need to compute it in Alteryx here.
How can I add this 4th column to the dataset? I can get the total count of each just fine, but counting up from 1..N is where I'm getting stuck.
| studentid | feeid | transactionid | R |
| A | 1 | 123456789 | 1 |
| A | 2 | 123456789 | 1 |
| A | 3 | 123456789 | 1 |
| A | 3 | 123456789 | 2 |
| B | 1 | 987654321 | 1 |
| B | 2 | 987654321 | 1 |
| B | 2 | 987654321 | 2 |
| B | 2 | 987654321 | 3 |
