Add Standardization (Z Scores) to Summarize tool

[Gtrujillo]

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. 

[KevinMcCoy]

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.

[JP02]

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

[CristonS]

Thanks for your feedback! Due to the existence of the gallery macro referenced above, there are no plans to include this feature.

[Gualigee]

Hi @KevinMcCoy， Can you please tell me where I can download such tools?

[JamieHankins]

I would also be interested in this macro, but the link does not seem to work?