The cell has truncated characters after summarize concatenate

[hemant86]

HI All,

I'm using a summarize tool to concatenate my data. Now what's happening is the values in the column are getting truncated. I tried using various string formats like W_string / V_Wstrings, also tried increasing the size of  the string but no luck. One more thing which I noticed is the values are also getting repeated. I cant see the whole value in the cell viewer but when I produce it on a excel file I see values are getting repeated. the max number of value possible per employee is 28.

Cell View:

Please see the output file attached.

[ShankerV]

Hi @hemant86 

Can you please share the input. And just the expected output.

So can try alternative way instead of summarize tool to reach the result.

Many thanks

Shanker V

[Raj]

can you share the sample output you are looking for

[hemant86]

Hi @ShankerV @Raj .,

Sharing the sample workflow package below 

[ShankerV · Accepted solution]

Hi @hemant86 

You are having multiple issues mentioned. Breaking down into pieces to have a better solution.

Issue 1: You have mentioned that, you have duplicated values.

Yes, it is because if you have 2 records or more in the same dataset then while you join it will create multiple records.

In the sample workflow you have shared, I have added a record to explain in detail.

To avoid the duplication, you need to have unique record in the both the datasets.

If any dataset contains more than 1 record for the same ECode, then it creates repeated value in the summarize tool.

Note: If you correct this issue, the trimming of values post summarize will get resolved as you can have max 28 values as per the dataset.

Many thanks

Shanker V

[hemant86]

Thanks @ShankerV . I did not realize that. Will work on eliminating the duplicates. Thanks Again!!