Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi Row Formula, [row-1] for first row

rs1
7 - Meteor

Hi,

 

I am trying to calculate rank using multi row formula tool. I want to assign same rank to same score, and all ranks should be consecutive (No missed numbers) (Similar to Golf)

I am using this calculation -

 

If [Count]<[Row-1:count]
then ([Row-1:Rank2] +1)
else [Row-1:Rank2]
endif

 

It is giving me desired results, but it's starting from 0. I need to start it from 1. 

rs1_0-1614878642501.png

 

Selecting "Set Values of closest valid row" for values for rows that don't exist should do the trick? But it's not. I think I understand it wrongly. Can anyone please clarify what this really means? And how to achieve this?

Any help would be great. Attching workflow for reference

 

Thank you!

 

4 REPLIES 4
patrick_digan
17 - Castor
17 - Castor

@rs1  I would try 1 of these two things:

1) Apply a min max of 1

 

max(1,
If [Count]<[Row-1:count]
then ([Row-1:Rank2] +1)
else [Row-1:Rank2]
endif)

 

2) Set the don't exists to "null" and then set nulls to 1

 

 

If isempty([Row-1:Rank2]) then 1 
elseIf [Count]<[Row-1:count]
then ([Row-1:Rank2] +1)
else [Row-1:Rank2]
endif

 

patrick_digan
17 - Castor
17 - Castor

@rs1 See attached workflow with both of my answers. You could also use the tile tool.

rs1
7 - Meteor

Thanks @patrick_digan

sgwong
8 - Asteroid

Is it feasible using multiple rows formula to obtain from the input to output?

Labels