Dynamic set max field size?

[Hamder83]

Hi 
Is there a way to decrease size of a column to max ex. 255? Across all fields in the datastream?

[caltang]

Perhaps this discussion is of interest to you: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Set-Field-Lengths-in-Select-To... 

[caltang]

You can also try the https://help.alteryx.com/20231/designer/auto-field-tool - but your results may vary.

An alternative would be to use the Multi-Field Formula tool, and tick the "Dynamic or Unknown field", and change the Data Type to string and set the size. Then it's dynamic. 

[danilang]

Hi @Hamder83 

Why do you want to reduce the field size?  The V in the type stands for variable.  The size in the type definition is the maximum length of string that can be stored in the field without truncation.  The actual amount of memory used is determined by the actual lengths of the strings in the column and not the maximum size.  

Dan