Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

formulat tool truncate

jasonshao
6 - Meteoroid

So I'm trying to modify a string field by adding a string to it. And it truncates the added part. It is not a size error because I changed it to VW_String and it's still the same. As shown by the example, I have a string field "abc" and im trying to add "def" and the output is still "abc" with "def" being truncated. I can actually do "def" + [field1] and that would give me my result but I want "abcdef" obviously. It works if I add a new field but I have to put a select tool to deselect the original which is painful as this is an example and the real workflow is much more complex.

Does anyone know how to solve this issue?

3 REPLIES 3
binuacs
20 - Arcturus

@jasonshao Change the size in the select tool

binuacs_0-1662668729678.png

 

jasonshao
6 - Meteoroid

I have it on V_WString which is supposed to be the biggest size. I tried all the string types still does the same, only "abc"

jasonshao
6 - Meteoroid

Oh See sorry you mean the number thank you!

Labels