Good Morning All,
I have a question:
Has anyone hardcoded a value and concatenated the hardcoded value with a existing value and updated the field with the new value in the Alteryx application?? I have been working on this for a entire day and I cannot figure it out. Any sugestions would be greatly appreciated. I am trying to concatenate a character at the begging of the field
Hello @alfraa ,
I see what you are doing. Ok replace the formula with this.
IF Length([teststr]) < 6 then '0' + [teststr] else [teststr] endif
What the above is doing is add a zero to the begining of the string the length is < 6.Otherwise, it leaves the string as it is.
If you want the o after the string then, the formula will be like the below
IF Length([teststr]) < 6 then [teststr] + '0' else [teststr] endif
Let me know if any issues
THANKS SO MUCH!!! IT WORKS !!! HAVE A GREAT DAY!!!!
I guess this shouldn't be a problem. So I dont start guessing your scenario, please a sample input will do it.
In the condition I am testing string length to make sure the string is less than six and if so hard code a "0" in front and update the Certifier Field
