Ensure the same number does not appear in the next row (in one field)

[Data_Alter]

I have this data where I don't want the same account number to be in the next row

Account Number	Document Number	Amount
100	ABC	700
100	ABC	-700
200	ABC	800
300	ABC	-800
500	ABC	-700
500	ABC	700

I want a dynamic workflow where same account number is never in next row.

An example of result would be

Account Number	Document Number	Amount
100	ABC	700
500	ABC	-700
200	ABC	800
300	ABC	-800
100	ABC	-700
500	ABC	700

[messi007 · Accepted solution]

@Data_Alter,

Please see below :

1- Unique tool in order to have on row per account number on the U anchor

2- Union with set specific output order

3- Below the final result

Hope this helps,

Regards,

[binu_acs]

@Data_Alter another way of dong this with the help of the Tile tool