Concatenate to create unique ID

[LeoMessi]

Hi Community,

I am trying to create a unique ID using three fields in dataset. Assuming this can be done via formula tool. Can you guide me how to do this?

Many thanks!

[ShankerV · Accepted solution]

Hi @LeoMessi 

tostring([ID])+[Date]+tostring([Amount])

Many thanks

Shanker V

[LeoMessi]

This worked really well for me, Shanker! Thanks a lot!