Add to V-String Column

[NBPSE]

I am trying to add "0000" 4 zeros to the end of my current v-string column. I am using a formula tool, the Column = Column + "0000" and it isn't adding the zeros. Do you know why this could be happening, or a better way to do this?

[abacon]

@NBPSE Check out this thread, it will get you the right answer.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Adding-Zeros-in-Front-of-a-Num...

Bacon

[binuacs]

@NBPSE make sure the result is not truncated because of the field size

[atcodedog05 · Accepted solution]

Hi @NBPSE,

Here is a solution.

@abacon, Pad function is not a right method for this since it might trim of number of "0"s based on string overall length. Refer below.

Hope this helps : )

[abacon]

@atcodedog05 Great call, I clearly misread the post. Thank you for correcting me on this.

Bacon

[atcodedog05]

No worries, happens 😅

Happy to explore and learn together 😁

[NBPSE]

Thank you! I did this same thing yesterday and it didn't work, but it is working today. Thank you for your help!

[NBPSE]

If the field size is too long it will automatically truncate the result?

[atcodedog05]

Hi @NBPSE ,

If the data string is longer than set datatype size than it will truncate.

[atcodedog05]

Hi @NBPSE,

Refer to this attached workflow.

Hope this helps : )