Adding Interface Tools to Pearson Correlation Tool

[caltang]

I’m trying to add a List Box to the Pearson Correlation tool and I’m pretty gobsmacked to see the need to change each individual variable to get it to work! 

Will changing it via Formula or XML work? I’m not sure what I’m doing exactly on the XML, would appreciate some pointers!

Trying to make an analytic app that covers all analytical tools so my end user doesn’t have to worry about workflows!

[caltang · Accepted solution]

I found a post : https://medium.com/@dobiasz.laszlo/i-recreated-and-enhanced-the-pearson-correlation-tool-in-alteryx-... by Laszlo Dobiasz.

Adding interface tools to his Macro really helped. 

I can't find his community profile, but Laszlo, if you see this, all credit goes to you. 

This macro is a lifesaver! 

EDIT: 

https://www.thedataschool.com.au/laszlo-dobiasz/i-recreated-and-enhanced-the-pearson-correlation-too...

Credit goes to the Data School as well! Fantastic work guys.

[caltang]

I've made some changes to the Macro whereby RecordID inputs are not duplicated at the end, and a sort is delivered to ensure field names in the matrix are consistent and linear.