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.
Solved! Go to Solution.
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 😀
it shows V_String and if i change it to number then the formula i have entered does not work.
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.
Hi @czjames87
Remove ToString() function and try
PadRight([Delivery],25," ")
Try increasing the size of field in select tool.
that worked. Thank you!
Happy to help 🙂
Cheers and happy analyzing 😀
Any idea if this works with 'Render' tool?