Hi Team,
I am looking for a solution in Alteryx designer. I want to increment the value in ID column based on the available number. can someone please advise?
Input
Customer | ID |
C1 | 28 |
C2 | |
C3 | |
C4 | |
C5 |
Required Output
Customer | ID |
C1 | 28 |
C2 | 29 |
C3 | 30 |
C4 | 31 |
C5 | 32 |
Solved! Go to Solution.
Hi @akanchar
You could use a multi-row formula tool. See below, if the ID field is blank it looks to the previous row's value and adds 1.
This worked. Thank you