Sorting a Column based on a repeating pattern?

[tschmied]

Hi Everyone,

I am trying to sort a column based on a repeating criteria. There are other columns in my data but as long as the other row info moves with the sorting it does not matter. I just need it to repeat:

Number:
1
2
3
1
2
3
1
2
3

Is there any way to do this?

[aworker]

Hi @tschmied

Please find a possible solution below based on the -Rank- node:

Rank

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