duplicate rows and then add leading zeros to the duplicates

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.

ISF workflow.xlsx

Help

Accepted answers

mceleavey

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.

solution.yxmd

All comments

apathetichell

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

mceleavey

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.

solution.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703