Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Record ID based on Grouping

JDong
8 - Asteroid

Hi All,

 

Please refer to the below data. I want to derive the recordID column that is unique for every name.

 

Can you please help.

 

Sl NoNameRecordID
1Apple1
2Apple2
3Apple3
4Orange1
5Orange2
6Grapes1
7Grapes2
8Brocolli1
9Brocolli2
10Strawberry1

 

Thanks

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

Here's a macro that we created to simplify this request:

 

https://gallery.alteryx.com/#!app/CReW-GroupByRecordID/5e417bbf0462d70decb763a9

 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
JDong
8 - Asteroid

Great !

 

Would this tool work when published the gallery ? 

 

Also when we share the flow will we need to do any additional steps to ensure it works on the other systems ?

atcodedog05
22 - Nova
22 - Nova

Hi @JDong 

 

Answer to your scenario is Tile tool set on unique value and unique value is name.

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Tile/ta-p/30235

https://help.alteryx.com/current/designer/tile-tool

 

Hope this helps 🙂

JDong
8 - Asteroid

@MarqueeCrew 

 

Just realized this tool does not work on 2019.1 designer or gallery ?

 

Any thoughts on how to fix the issue ?

 

Gallop_0-1614251450567.png

 

Thanks

Whodathunkit
7 - Meteor

For anyone looking at this since it was posted in 2021, try using the Tile tool which is in the Preparation section of tools.

Labels