Field Summary - Shortest_Value & Longest_Value returns NULL of FixDecimal

Question

I am running the Field Summary tool against a data set Shortest_Value & Longest_Value in the tools response return NULL for FixDecimal fields.

I can understand the return of NULL for the Shortest_Value, but was surprised that the Longest_Value returned NULL also.

Is there anything I can do or change with the tool that would return the actual Longest_Value?

Thanks,

Puff

danilang · Accepted Answer

Hi @stapuff

The longest and shortest values return Null for fixed decimal, because the concept of longest and shortest isn't applied to numbers(in Alteryx, anyway)

This is the output for 3 fields of data with same 2 values.  You see that for numeric values you get max, min, and other statistical information.  For the string value, you get common string related stats.

If you need to see longest and shortest numeric values, convert them to string, as in the attached

Dan