Hi @tschmied
Please find a possible solution below based on the -Rank- node:
If I got it right, the workflow preserves the other rows info order as needed, for instance:
- Initial unsorted dummy example data:
- The result:
As you can see on the highlighted ones, the order of ones is preserved given their initial Row Index (1, 6, 7, 11).
20210927 Pikairos Sorting a Column based on a repeating pattern.knwf (29.8 KB)
Hope this helps.
Best
Ael