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.
- How would perform the equivalent of a GROUP BY and HAVING Clause
SELECT A, Count(*)
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)