How to Increment in Alteryx

While Alteryx has many great functions right out of the box, I realized one thing they’re lacking is an increment function (or at least I haven’t found one).  Anyone who’s worked with SQL is familiar with the Identity data type that allows you to specify a seed and an increment value as follows:

IDENTITY [ ( seed , increment ) ]

This allows you to create a column that automatically generates new, unique integers by incrementing the starting “seed” value.

Occasionally when loading text-based keys or natural keys into a normalized database it’s helpful to be able to generate incremented IDs.  Below is a snapshot of how I was able to accomplish this in Alteryx using the multi-row function.

The first data input is simply an excel file with a column of text values (item descriptions) as seen below.

Continue reading “How to Increment in Alteryx”