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

creating a RecordID for rows that have similar info

codyfawcett
6 - Meteoroid

I have a set of data that includes IP in column1 with header IP_Address

there are multiple rows that have the SAME IP, and I would like to increment the RecordID by 1 based on the IP
you can see a sample of the sanitized data below.

Screen Shot 2019-05-02 at 12.36.37 PM.png

 

I am looking to get a record number added in the last column starting at 1 and as it finds a new IP in increment +1

so it would resemble this
Screen Shot 2019-05-02 at 12.40.07 PM.png

I am trying to use the Multi-Row Formula tool
Screen Shot 2019-05-02 at 12.41.32 PM.png

 

It almost works but it isn't incrementing correctly.  
Would anyone be able to help me out with the correct formula or tool for this?

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @codyfawcett 

 

Use Tile Tool with Unique Value method. Unique field being your IP address. Much easier.

 

Uniquefield.PNG

 

 


Cheers,

codyfawcett
6 - Meteoroid

Thanks for the super fast response!  that is exactly what I was needing.  used the unique fields no grouping then used the Tile_num as the incrementer.

 

Thanks!

Labels