community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Add Standardization (Z Scores) to Summarize tool

Would be extremely useful if the Summarize Tool had an option in the numeric menu to Standardize the data.  More often than not, data sets will not have the same count of variables which makes the comparison analysis meaningless.  Currently, there is no easy way to Standardize the data without using the K-Centroids Cluster Analysis tool or standardize_unit interval supporting macro. 

2 Comments

I created a macro that will normalize/denormalize datasets. Additionally, it will also normalize new datasets based off of the parameters from your initial model building normalizing metrics (so that you can use an old model on new data).

 

It's located at Feature Normalization.

Meteor
Kevin, Thanks for sharing the macro. I am new to Alteryx and trying to fully understand the macro you built. If I have a dataset which contains a score feature, with a normal range from 75-150, and I want to use your tool to normalize the data in that column, how would I do that? I have found errors in the dataset (e.g. 750) which are outside the normal range. Any assistance with your macro would be most appreciated. VR Jacob