One of the most common questions I get about Alteryx is: “How can I make my module run faster?”  Although Alteryx can be very fast, since it is such a general tool, it is only as good as the module that you have authored.  There is a very simple guideline that you can follow to make a module faster:  do less work.  The most common example of doing less work is to use the select tool as early as possible to remove fields that you are no longer using.  In order to walk you through the process I use to make an Alteryx module run faster, I am going to walk through the process of optimizing my Percentile Macro to run as fast as possible.

Continue reading →