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.