How to create unique ids for unique items

[Shelaj]

Hi,

I'm looking to create a unique ids using my process_id 

and I want the unique ids to be start again once the process ids changes as shown below

Kindly help 🙂

[Ladarthure]

Hi @Shelaj,

You can use a multi-row formula:

and just tick the group by session. and have a formula like [row-1:id]+1

(find an example attached)

[AshleyL]

Hi @Shelaj --

After you use the multi-row formula, you can convert the number into a string using a formula to add the S and 0 to the UID like described in your question.

I've attached a workflow with the multirow and formula configuration.

Best,

Ashley

[DavidP · Accepted solution]

I like using the Tile tool for this kind of thing

[Shelaj]

Hey David,

Thanks for the solution, it worked totally fine 🙂

[Shelaj]

Hey AshleyL

Thank you very much, the solution worked well 🙂

[Shelaj]

Hey Arthur

Thank you very much for the solution, provided solution worked great 🙂

[ll98]

I have something similar where I want to add a unique value to multiple columns to make them unique to the DB.

LEID	Investor ID	Transaction ID	Batch ID	Fund ID
195	458766	859	7895	14566
US1-195	US1-458766	US1-859	US1-7895	US1-14566

So I would want like a prefix into some of the columns of the report