Row_Number() function in SQL to Alteryx

Hi Alteryx Community,

Does anyone have a simple workflow that would implement Row_Number() Over(Partition by Field_1, Field_2 order by Field_3 DESC)?

This use case will be useful to my projects and future projects because we always use ranking function.

Thank you

Mark

Datasets

Accepted answers

BenMoss

Certainly this is possible.

Start by sorting your data by field 3.

Then use the multiple formula tool. Check the create new field option and let's call this ID.

You can the use the statement

[Row-1:ID]+1

Then specify field 1 and field 2 as group by criteria. This means the row number will restart accordingly.

Ben

All comments

BenMoss

msedrech0114

WOW! can't imagine it's that simple!

Thank you Ben! It works perfectly!

harishketha

Thanks this helps

Heidi__dup_127

Thanks! Can you share a screen shot of how the Multi Field Formula tool is configured for this question? I'm not finding the "create new field" option on the tool in version 2019

Thanks in advance!

Heidi

benakesh

Hi @msedrech0114 ,

Another option for row_number and partitioning is tile tool .

row_number.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703