Unwanted truncation for Concatenations

[aka_ash]

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

Test	Expected 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

[apathetichell]

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]

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]

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

[Darrie8468]

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

[apathetichell]

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

[Darrie8468]

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

Thanks!