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.

Unwanted truncation for Concatenations

aka_ash
8 - Asteroid

Hi,

 

I am currently trying to concatenate large sets of strings into a single field however my data keeps getting truncated.

The data is being loaded via a CSV and i have also tried setting the field Length to a large number but still see truncation at input and after summary tool

Below is some sample data and expected output and also some screenshot of what I get.

 

I am hoping someone can assist in me getting the expected output (No truncating data)

THanks in advance

 

TestExpected output
Data Red_1,Data Red_2,Data Red_3,Data Red_4,Data Red_5,Data Red_6,Data Red_7,Data Red_8,Data Red_9,Data Red_10,Data Red_11,Data Red_12,Data Red_13,Data Red_14,Data Data Red_1,Data Red_2,Data Red_3,Data Red_4,Data Red_5,Data Red_6,Data Red_7,Data Red_8,Data Red_9,Data Red_10,Data Red_11,Data Red_12,Data Red_13,Data Red_14,Data Red_15,Data Red_16,Data Red_17,Data Red_18,Data Red_19,Data Red_20,Data Red_21,Data Red_22,Data Red_23,Data Red_24,Data Red_25,Data Red_26,Data Red_27,Data Red_28,Data Red_29,Data Red_30,Data Red_31,Data Red_32,Data Red_33,Data Red_34,Data Red_35,Data Red_36,Data Red_37,Data Red_38,Data Red_39,Data Red_40,Data Red_41,Data Red_42,Data Red_43,Data Red_44,Data Red_45
Red_15,Data Red_16,Data Red_17,Data Red_18,Data Red_19,Data Red_20,Data Red_21,Data Red_22,Data Red_23,Data Red_24,Data Red_25,Data Red_26,Data Red_27,Data Red_28,Data Red_29,Data Re 
d_30,Data Red_31,Data Red_32,Data Red_33,Data Red_34,Data Red_35,Data Red_36,Data Red_37,Data Red_38,Data Red_39,Data Red_40,Data Red_41,Data Red_42,Data Red_43,Data Red_44,Data Red_45 

 

aka_ash_0-1629684090697.png

aka_ash_1-1629684161314.pngaka_ash_2-1629684240566.png

 

 

6 REPLIES 6
apathetichell
18 - Pollux

Try this - add a select tool between the input data and the summarize. Use the select tool to manually increase the size of the text field. There is a bit of Autofield-ing (automatically shrinking the size of the text field) that can go in after the input data tool so your summarize tool is truncating it.

ncrlelia
11 - Bolide

Hi @aka_ash,

 

The results view has a limit on the length of text displayed, your data is still there. Adding a Browse tool will allow you to see the full text.

 

Hope this helps.

 

Cheers,

Lelia

 

 

binay2448
11 - Bolide

Find attached my solution, it is working fine for me...

Darrie8468
8 - Asteroid

Interesting..  I did not change your workflow at all, just downloaded it, and I got this result from the Browse Tool.  I am using Version: 2022.1.1.25127

 

Darrie8468_0-1661174820585.png

 

apathetichell
18 - Pollux

That isn't truncated data. That's the size of the browse window. Export that data or copy it into notepad.

Darrie8468
8 - Asteroid

I got it.  Yes.  That is right.  It is fine when I exported it.

Thanks!

Labels