String truncation after Summarize-Concatinate

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?

Tips and Tricks

Accepted answers

Maybe a multirow formula tool, where you add contents of Row-1 to Row from Col B values in a new field, grouped by Col A? So the final row of each Col A group has the full concatenation of Col B values, and you filter/include only those rows downstream? Sorry it's just a suggestion and not a solution, but I thought it might help.

All comments

JohnJPS

Hi @dakeefe

Just curious - what happens if you were to first run it through a Select tool, and specify a V_String (variable-length string) for Column B, and give it a very long string length. Does it still truncate?

Hope that helps!

John

dakeefe

John:

Thank you for your suggestion. I'm using the V-WString data type since the strings contain "-" and adjusted the length to 5000, but I'm still getting truncated data:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703