Summarize tool - limiting characters and replacing them with dots
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All!
I have an issue with Summarize tool because it doesnt show all data and replace them with dots as below:
('254900OB61KVCB6LOU24','31570020000000005900','549300DKATF11MXSJK67','549300IZFH207CSRWR87','549300TB4U4ZYTEG6B43','54ZMQ1M7YQYKOZC8E043','743700QE8NLDSS1B0055','254900ITOI19I4I7I707','31570020000000005803','549300BYWOXNH286YR10','549300FVFD5HBP6XE830'...
So it shows just 11 numbers and there are 16 of them (8 under VenueCptyLEI and 8 under RefDataCptyLEI) so I would like to have all of them (16). Could you please help me should I change the data type or something else? I sent the workflow in the attachment.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@howyoudoing you should see 14 in the output except the 2 duplicates
('254900OB61KVCB6LOU24','31570020000000005900','549300DKATF11MXSJK67','549300IZFH207CSRWR87','549300TB4U4ZYTEG6B43','54ZMQ1M7YQYKOZC8E043','743700QE8NLDSS1B0055',
'254900ITOI19I4I7I707','31570020000000005803','549300BYWOXNH286YR10','549300FVFD5HBP6XE830','549300IZFH2O7CSRWR87','AV7QJSDB1GI2P6FRGL71','EERY7DYADTAIDSOZ1077')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The values are likely there - use a Browse tool and check the Cell Viewer to see
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I see two seperate lines as below in the Union tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i added a different union tool to see the total records before the concatenation operation, ae you still seeing the count as less than 14? as discussed did you upgraded the designer to latest version
