duplicate rows and then add leading zeros to the duplicates

[LRC]

Hi, I need some help on how to create duplicate rows and then add enough '0's to the duplicates to have ten digits.  So I need one set of IDs to be 'as is' and a duplicated set to be ten digits.  in the attached file, the black IDs are the original, the blue IDs are what I want to create in Alteryx.  I have figured out how to generate rows, but I can't figure out how to add the 0 to only some of the rows, so not sure if that is the best way.  Thanks for any help.

[apathetichell]

padleft([Associate ID],10,"0")

[mceleavey · Accepted solution]

Hi @LRC ,

Very simple, my friend. 

You simply need to take the stream into a formula tool, use the Padleft() function, and union back together:

I've attached the workflow for you.

Hope this helps.

M.

[LRC]

Hi @mceleavey, Thank you very much for the solution and quick response. I read through it, understand what you did, and plugged it in successfully. I appreciate your help. Lynn

[mceleavey]

Hi @LRC ,

No problem at all. I happened to be at my PC despite my incredibly rich and varied social life.

M.