Record ID based on Grouping

[JDong]

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 No	Name	RecordID
1	Apple	1
2	Apple	2
3	Apple	3
4	Orange	1
5	Orange	2
6	Grapes	1
7	Grapes	2
8	Brocolli	1
9	Brocolli	2
10	Strawberry	1

Thanks

[MarqueeCrew · Accepted solution]

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

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

cheers,

 mark

[JDong]

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]

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]

@MarqueeCrew 

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

Any thoughts on how to fix the issue ?

Thanks

[Whodathunkit]

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