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.

Validation.xlsx

ShankerV

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

Sample used to explain.yxmd