Hi I am building a larger workflow where I don't want adjacent rows for the account number column should not be same
Basically if the dataset looks like this
Document Number | Account Number | Amount |
d | 1000 | 5.00 |
d | 1000 | - 5.00 |
d | 2000 | - 5.00 |
d | 2000 | 5.00 |
e | 8000 | 10.00 |
e | 8000 | - 10.00 |
e | 8000 | 10.00 |
e | 8000 | - 10.00 |
e | 9000 | - 10.00 |
e | 9000 | 10.00 |
e | 9000 | - 10.00 |
e | 9000 | 10.00 |
It should look like this
Document Number | Account Number | Amount |
d | 1000 | 5.00 |
d | 2000 | - 5.00 |
d | 1000 | - 5.00 |
d | 2000 | 5.00 |
e | 8000 | 10.00 |
e | 9000 | - 10.00 |
e | 8000 | - 10.00 |
e | 9000 | 10.00 |
e | 8000 | 10.00 |
e | 9000 | - 10.00 |
e | 8000 | - 10.00 |
e | 9000 | 10.00 |
Solved! Go to Solution.