interrogating mixed fields

I have a data set of mixed fields, some numeric , some strings. i want to look at "statistics" on it, looking for nulls, looking for numeric ranges, looking for all unique values, etc... i know i can put a bunch of summarizes in there, group by each field and count but is there a better way? I tried "Field summary" but "shortest and longest" value of strings isn't what I need. other ideas? thanks

becki kain

Expression

Accepted answers

DultonM

Hi @becki,

I made a macro awhile back that creates a unique list of all the values that appear in each column. The macro is called "List Field Values" and is available on the Alteryx Analytics Gallery here. This should at least address the "looking for all unique values" portion of your request. Furthermore, if you see Null in a column's list, that means that at least 1 Null record is present. You can edit the macro to give you more information, such as the counts of all the list values. Hope this helps!

All comments

GavinAttard

Is the built in feature (data profiling) not what you are looking for?

Stick a browser on your data input and click on a field to see these stats in the configuration window.

cheers

Gavin

JoeS

Hi @becki

As well as the above mentioned statistics you can get from the profiling within the browse tool.

There is also the Field Summary tool, available within the Data Investigation section of the tool palette.

This will be similar statistic to that of the browse along with a few others, and the biggest differentiation is the interactive output for each column as well.

becki

sort of. that helps at least with a field that should be string and is showing as numeric but not quite all of what I want but it is another tool to use. thanks!

DultonM

Hi @becki,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703