Length of String

rakshabhat

Hi team,

I am working on a large Alteryx Database with about 350 fields and 40 million lines. 

I would like to know the length of all the string fields without having to write length formula for each field. I know that in Summarize, there is an option to get Max of a field, but it only works for numeric data type. 

Any help is appreciated. Thanks in advance!

afv2688

Hello @rakshabhat ,

Within the summarize tool, on the string functions there is one called "longest". This will give you the longest string on each field.

Regards

length field.yxmd