- How would perform the Alteryx equivalent of a GROUP BY and HAVING Clause
- How many ways are possible to go about it?
- What is the best practice in applying the Alteryx Equivalent?
SELECT A, Count(*) FROM TABLE GROUP BY A HAVING COUNT(*) > 1
Solved! Go to Solution.
Here's how:
Cheers,
Mark
Mark,
Thanks for the solution but I'm not sure why you are joining the output of the summarize/filter flow to the original data?
Doesn't the original SQL return counts by group A?
If Table contains:
A
---
XX
XX
YY
YY
YY
YY
ZZ
SELECT A, Count(*)
FROM TABLE
GROUP BY A
HAVING COUNT(*) > 1
Returns:
A | COUNT(*)
-------------
XX | 2
YY | 4
Isn't that what the result of the summarize & filter control would produce?
Maybe I'm looking at it wrong (it won't be the first time).
Thanks,
Lee