community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Size Limit

Meteoroid

Hi, 

 

I am using summarize tool to concatenate Email ids, but some of my fields are getting truncated due to length. 

Character length is 299. I tried using other datatypes like VW_String and WString but facing same issue. I have kept size limit as 10000 for V_String. Please help. Thanks!

 

Concatenate Warning.JPG

Field limits are typically in place for a reason, with this as what I assume to be a primary reason. It looks like you are taking a well formed, easily consumable schema and creating a jumbled list of items which will most likely be parsed out at a later date. All critiques aside, I would suggest using the Tile tool to perform an 'Equal Records' tiling and then I would Cross Tab. Keep in mind this WILL NOT REMOVE FIELD LIMITS, but it will offer you an easy work-around. If you find that after the Cross Tab you still have concatenated records, positively increment your tile count.

 

 

circumventFieldSizeLimitations.PNG

Nebula
Nebula

Hi @varunamin2 

 

The message that you're seeing about the string being truncated only applies the display in the Results window.  The Results window only displays 256 characters to reduce memory use and display time.  The underlying data is not truncated.  You can see this if you attach a Basic Data Profile to the output of your Summary tool

 

Here's a long string I created as viewed in the Results window

 

trunc.png

Here's the output of the Basic Data Profile tool showing that longest value is 1392 characters long

Fieldinfo.png

 

The value is still there in its original form.  It's just a limitation of the Results window

 

Dan

Meteoroid

Thanks Dan! Yes, its just the limitation of Result's window.

Labels