Alteryx Guide For SQL users

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!