Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

String truncation after Summarize-Concatinate

dakeefe
7 - Meteor

All,

 

I have two columns of string data, and am using the Summarize tool to first group by column A, then concatenate all of the strings in column B. However, Alteryx is truncating my data by default, and is only keeping the first 256 characters of the concatenation. I'll probably need as many as 4000 characters in a string, to then be passed through a join, append data, etc for analysis.

 

Is there a way to configure the Summarize tool to allow for longer strings after it concatenates?

11 REPLIES 11
zammar
7 - Meteor

Hello

 

What you are suggesting here might solve an issue I am having with a related topic. Could you share how you can build that in multi formula tool? This is for a new column that has concatenated values from all previous Column A values..

 

Mine is only concatenating values when values in Col A are the same.

w_chivers
7 - Meteor

Thanks @adm510 !  Changing the type to WString solved my issue. Cheers.

Labels