We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding a series identifier

dunkindonut7777
8 - Asteroid

Hi I have a data here that I want to add a unique identifier to each codes. See sample in the table below \:

 

CodeUnitUniqueIdentifier (ExpectedOutput)
10000ACRACR_1
10000ACRACR_2
20000ACRACR_1
20000ACRACR_2
20000GERGER_1
20000GERGER_2
30000ACRACR_1
30000REGREG_1
40000REGREG_2
50000GIIGII_1

 

I want to create an identifier every product code. How can I perform this?

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

Hey @dunkindonut7777, here's how I'd do that - just creating a grouped RecordID with the Multi-Row Formula tool, grouping by code. Then use a Formula tool to create the UniqueIdentifier.

binuacs
21 - Polaris

@dunkindonut7777 Another method with the tile tool

image.png

dunkindonut7777
8 - Asteroid

Thank you. It works

Labels
Top Solution Authors