Hello, I have 2 datasets, first data set contains all loans and 2nd data set contains list of auditors #1 to #5. I would like to loop auditors #1 to #5 for first data set of all loans, the loans number can vary every week could be any number, how can i design this logic using ALteryx, attaching my workflow with some sample data set, thank you.
Example Input:
| Loan# | Auditor Assigned |
| 11 | |
| 21 | |
| 31 | |
| 41 | |
| 51 | |
| 61 | |
| 71 | |
| 81 | |
| 91 | |
| Auditor # | Auditor Name |
| 1 | Aud 1 |
| 2 | Aud 2 |
| 3 | Aud 3 |
| 4 | Aud 4 |
| 5 | Aud 5 |
Example Output:
| Loan # | Auditor |
| 1 | Aud 1 |
| 2 | Aud 2 |
| 3 | Aud 3 |
| 4 | Aud 4 |
| 5 | Aud 5 |
| 6 | Aud 1 |
| 7 | Aud 2 |
| 8 | Aud 3 |
| 9 | Aud 4 |
