Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Summarize tool does not list all rows grouped

gdorwart
7 - Meteor

Currently, I'm trying to concatenate a few rows into one row using the summarize tool. However, at a certain character, instead of listing the other rows, it replaces them with "...". It seems like as soon as the summarize tool gets to a certain character count, it cuts the rest of the rows off.  Below is what it looks like when I pasted into an excel file. I tried changing the data type to V_string, Vw_string, changing their size, etc. but to avail. 

 

Capture.PNG

 

  Any help fixing this issue would be much appreciated!

2 REPLIES 2
Luke_C
17 - Castor

The results window only lists a preview of the data, so I'd expect this behavior if you copy out of there. What happens if you connect it to a proper output tool and export to excel? I'd expect the data is all there. 

gdorwart
7 - Meteor

That would be correct, thank you!

Labels