Alteryx Designer

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

Help with Rank

Highlighted
11 - Bolide

I've got some SQL that is returning a Rank - sort of.  It ranks the data and then repeats when the larger group changes.

 

Example:

 

1

2

3

4

4

4

7

8

8

10

1

2

3

4

5

5

7

...

 

 

 

I'm not sure why my SQL is doing that.  It's not my SQL for one thing and it's fairly complex.  How can I use - maybe - a Multi-Row Formula Tool (or some other tool) to look at the row before and if the same number then add 1?

 

Thanks in advance for any help.

 

 

 

 

 

 

Highlighted
8 - Asteroid

Using the Multi-Row Formula tool, select "update existing field" and use this formula:

 

IF [Field1] = [Row-1:Field1]
THEN [Field1] + 1
ELSE [Field1]
ENDIF

 

Replace [Field1] with the name of your field

Highlighted
11 - Bolide

2018-10-10_12-13-22.jpgNever mind.  I got it.

 

 

Highlighted
11 - Bolide

I like yours better.  Thx

Labels