Alteryx, by its core, is a SQL… but easier to learn and use for those who never learned to code.

 

That being said, SQL users should be able to use Alteryx in a very short period of time.

 

Below is a brief introduction of some Alteryx functions and their equivalent SQL codes:

SQL Alteryx
Select * from …

 

 The Browse tool displays data from a connected tool as well as data profile information, maps, reporting snippets, and behavior analysis information in the data.

The Select tool allows you to select the columns, that flow downstream, rename and reorder columns, modify data types, and add column descriptions.

GROUP BY

 

The Summarize tool can perform a host of summary calculations, including summing, min and max, grouping, counting, string concatenating, math, spatial object processing, and much more.
ORDER BY

 

The Sort tool arranges rows in a table in an ascending or descending alphanumeric order based on the values of one or more specified data columns.
UNION

 

The Union tool combines multiple data streams based on common column names or positions. In the output, each column will contain data from each input and rows will be stacked vertically.
JOIN

 

The Join tool combines 2 data streams based on common fields or record position. In the joined output, each row will contain the data from both inputs.

 

This is just a very quick introduction to Alteryx. Alteryx has more than 100 tools (and the developers are adding more tools every new release).

 

Learn Alteryx if you know SQL. It’s easier than you expect.

 

Have fun!

 

 

Luke Yin
Author: Luke Yin

Before joining the Data School, Luke was a PhD researcher studying urban history of global cities at the University of Melbourne. Previously, Luke worked as an internal accountant for a Melbourne local winery. When conducting urban research, Luke discovered his passion for data visualisation and analysis through a number of university-based digital projects. Later, this became the reason for him to join the Data School. Luke wants to combine his expertise in research and business with data analysis to help solve real-world problems.