ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

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

Record ID based on Grouping

Gallop
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

MarqueeCrew
19 - Altair
19 - Altair

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 reboot. Order shall return.
Gallop
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
17 - Castor

Hi @Gallop 

 

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 🙂

Gallop
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

Labels