Computing a rank index if values are identical

[mangogul (Christoph)]

Dear colleagues,

with dt.DefaultView.Sort, I can easily sort a table, determine the rank of a row, and write the rank index into a separate column.

See the workflow attached.

But: How can assign an identical rank index if the values in the column that is sorted are identical?

In my example, values in the rows ZweiA and ZweiB are both 8 while their rank is 2 and 3, respectively. But I want the rank for both to be 2.

Any ideas?

Thanks in advance
Christoph

Ranking.xaml (13.0 KB)

[Emman_Pelayo]

Hi Mangogul,

I added few lines of codes for checking of the rank per row on your workflow. see attached.

Ranking.xaml (14.8 KB)

[mangogul (Christoph)]

Hi Emman,
that’s great, many thanks for your efforts!
Sooner or later your solution should help other people, too.
Best wishes
Christoph