Table Input is the current data set, I am trying to create an extra column in the output table. If [RecordID] == 1 Then 1
Elseif IsNull([RecordID]) or [RecordID] <= [Row+1:RecordID] Then [SetID] + 1
Else [SetID] endif
| Input | ||
| RecordID | Column 1 | Column 2 |
| 1 | aa | 123 |
| 2 | ab | 345 |
| 3 | ac | 123 |
| 4 | ad | 234 |
| 5 | ae | 234 |
| 1 | aa | 123 |
| 2 | ab | 345 |
| 3 | ac | 123 |
| 4 | ad | 234 |
| 5 | ae | 234 |
| 1 | aa | 123 |
| 2 | ab | 345 |
| 3 | ac | 123 |
| 4 | ad | 234 |
| 5 | ae | 234 |
| output | |||
| RecordID | Column 1 | Column 2 | SetID |
| 1 | aa | 123 | 1 |
| 2 | ab | 345 | 1 |
| 3 | ac | 123 | 1 |
| 4 | ad | 234 | 1 |
| 5 | ae | 234 | 1 |
| 1 | aa | 123 | 2 |
| 2 | ab | 345 | 2 |
| 3 | ac | 123 | 2 |
| 4 | ad | 234 | 2 |
| 5 | ae | 234 | 2 |
| 1 | aa | 123 | 3 |
| 2 | ab | 345 | 3 |
| 3 | ac | 123 | 3 |
| 4 | ad | 234 | 3 |
| 5 | ae | 234 | 3 |
Solved! Go to Solution.
