cancel
Showing results for 
Search instead for 
Did you mean: 

Can there be a section devoted to performing SQL Equivalent functions...

I am proficient in SQL and new to Alteryx; I see the answer to many of problems quite easily through the SQL language but want to know how to translate much of that to Optimal Alteryx workflows and would if there are alternative approach to the same thing in Alteryx I like to be able choose the path that is most compatible with my Alteryx skill set at the time eg take the path using an Alteryx Tool; a Function, RegEx or other.

 

Examples: 

- How would perform the equivalent of a GROUP BY and HAVING Clause 

SELECT A, Count(*)
FROM TABLE
GROUP BY A
HAVING COUNT(*) > 1

- How would I perform the Teradata SQL equivalent of QUALIFY, RANK, ROWNUM and PARTITION BY

- How would I assign a PRIMARY INDEX upon creation of a table using the Alteryx output without having to create the table myself using SQL on Teradata itself (this is necessary to mitigate unnecessary storage usage resulting from skew)