Replace ID and add extra characters

[swapsingh2712]

Hello All,

I've a list of the test ID's that are available in the attached workflow, which is getting generated automatically.

so the requirement is  Test ID should be formatted as ‘TI’ + ‘XXX’, where XXX is 3 digit integer. Tool is currently excluding leading zeros. Eg I am seeing ‘TI2’ instead of ‘TI002

and if it's 12th record it should show as  'TI012'.

Could you please advise how to format these ID's

Please find my workflow in the attachment

BR

swapsingh2712

[atcodedog05 · Accepted solution]

Hi @swapsingh2712 

Us this formula

'TI'+PadLeft([Max_TEST_ID],3,"0")

Hope this helps : )

[binuacs]

@swapsingh2712 updated your workflow 

[atcodedog05]

Happy to help : ) @swapsingh2712 

Cheers and have a nice day!

[swapsingh2712]

Thank you so much for your help.

I need help with another alteryx workflow. Will post the question shortly. Hope you'd be able to help :)