Inspiring Ingenuity

Alteryx, Bicycles and Teaching Kids Programming.


Alteryx: Aggregate Formulas

Aggregate Formula SampleOne of the really great strengths of Alteryx is that is can handle any amount of data that you throw at it.  If your data is small enough, it might all be in memory, but when Alteryx gets more data than fits, it silently swaps out to disk.  This way people are routinely processing data sets that are 2, 10 or even 100 times bigger than they have enough memory for!

Mostly the user never notices this aspect of the Alteryx engine and it just works.  There are times though when we get feature requests that would be much easier to implement if all the data was in memory.  One example of that is aggregate functions in the formula tool.  Since other desktop products that are similarly easy to use, like Tableau and Excel, have simple SUM and AVG type functions in their formulas, it is assumed that Alteryx would too. Continue reading

Advertisements


2 Comments

Alteryx: Regular Expression Tokenize

Before I start, let me say that I am looking forward to seeing lots of my readers next week at Inspire.  You will most often find me in the Solutions Center.  Please don’t hesitate to come ask questions, give suggestions or just chat.  I love the opportunity to teach & learn.

Recently I got a question on our internal support board:  How do I parse a file that is Ctrl-A delimited?  Normally for reading delimited files you just read the file as a CSV and set the delimiter in the input settings and you are done.  The problem with Ctrl-A is that it is a special (unprintable) character and it is not possible to set in the GUI.  The normal backup for parsing issues like this – the Text To Columns tool – has the same limitation. Continue reading