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 · Accepted solution]

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

[rakshabhat]

Thanks a lot 😊