Size Limit

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

Preparation

Accepted answers

danilang

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

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

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

Dan

All comments

cjwaldron18

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.

danilang

Hi @varunamin2

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

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

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

Dan

varunamin2

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703