Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Summarize tool - limiting characters and replacing them with dots

howyoudoing
8 - Asteroid

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!

4 REPLIES 4
binuacs
21 - Polaris

@howyoudoing you should see 14 in the output except the 2 duplicates

image.png

('254900OB61KVCB6LOU24','31570020000000005900','549300DKATF11MXSJK67','549300IZFH207CSRWR87','549300TB4U4ZYTEG6B43','54ZMQ1M7YQYKOZC8E043','743700QE8NLDSS1B0055',
'254900ITOI19I4I7I707','31570020000000005803','549300BYWOXNH286YR10','549300FVFD5HBP6XE830','549300IZFH2O7CSRWR87','AV7QJSDB1GI2P6FRGL71','EERY7DYADTAIDSOZ1077')
alexnajm
17 - Castor
17 - Castor

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

howyoudoing
8 - Asteroid

I see two seperate lines as below in the Union tool 123.PNG

binuacs
21 - Polaris

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

image.png

Labels
Top Solution Authors