Summarize tool - limiting characters and replacing them with dots

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!

summarize tool.yxmd

Workflow

Developer

Reporting

Settings

Topic of Interest

Transformation

Help

In Database

Text Mining

Data Investigation

In-Database

Accepted answers

binu_acs

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

All comments

binu_acs

@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')

alexnajm

The values are likely there - use a Browse tool and check the Cell Viewer to see

howyoudoing

I see two seperate lines as below in the Union tool

binu_acs

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335