Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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