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.
Solved! Go to Solution.
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
can you share the sample output you are looking for
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
Thanks @ShankerV . I did not realize that. Will work on eliminating the duplicates. Thanks Again!!