Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Record ID based on Grouping

AlteryxGallop
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

4 REPLIES 4
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.
AlteryxGallop
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 @AlteryxGallop 

 

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 🙂

AlteryxGallop
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