Column Width Error

[czjames87]

I am trying to resize several columns in my workflow based on character length. I have managed to succeed using the below formula. However, when i attempt to save my flow I get this error even though my flow runs with no errors. All fields are V_String before and after the formula tool I am using. I tried using tonumber as well but in order to use PadRight the datatype has to be string. Any help would be greatly appreciated. 

PadRight(ToString([Delivery]),25," ")

The error i get when i attempt to save.

[atcodedog05]

Hi @czjames87 ,

check this datatype it should be number

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀

[czjames87]

it shows V_String and if i change it to number then the formula i have entered does not work. 

[atcodedog05]

Hi @czjames87 

It should be string not double.

[czjames87]

Below is what the formula tool is showing. As you can see the data type is string. However, when i go to save it says its a number field 

Below is the select tool that i am using right before the formula tool. which also shows that this a string datatype. Not sure how it shows as a number when its showing as a sting throughout the flow. 

[atcodedog05 · Accepted solution]

Hi @czjames87 

Remove ToString() function and try

PadRight([Delivery],25," ")

Try increasing the size of field in select tool.

[czjames87]

that worked. Thank you! 

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀

[sfyodor]

Any idea if this works with 'Render' tool?