Concatenated the hardcoded value

[alfraa]

• 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

[ImadZidan]

Hello @alfraa ,

I guess this shouldn't be a problem. So I dont start guessing your scenario, please a sample input will do it.

[alfraa]

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 

[ImadZidan]

Hello @alfraa ,

This is an example of using the formula and output 0 or 1 or other string value.

I also included to output as a bool.

Hope it helps

[alfraa]

I added but I am not sure what this does not do anything. No data is brought back we have values with the correct string length of 6 or more. I only want to concatenate a "0" character to the fields that has only 5 characters, this is not doing that 

[ImadZidan · Accepted solution]

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

[alfraa · Accepted solution]

THANKS SO MUCH!!! IT WORKS !!! HAVE A GREAT DAY!!!!