core.noscript.text
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?
Solved! Go to Solution.
@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
@NBPSE make sure the result is not truncated because of the field size
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 : )
@atcodedog05 Great call, I clearly misread the post. Thank you for correcting me on this.
No worries, happens 😅
Happy to explore and learn together 😁
Thank you! I did this same thing yesterday and it didn't work, but it is working today. Thank you for your help!
If the field size is too long it will automatically truncate the result?
Hi @NBPSE ,
If the data string is longer than set datatype size than it will truncate.
Refer to this attached workflow.
