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

[FogoFortitude]

- 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

[MarqueeCrew · Accepted solution]

@FogoFortitude,

Here's how:

• SUMMARIZE
  • Groupby A
  • Count A
• FILTER the output of the summarize with
  • Count > 1
• Join the original data (going into the summarize) with the output of the Filter on A = A
  • Unselect the RIght_A field and the Count field

Cheers,
Mark

[lrygiel]

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

[MarqueeCrew]

@lrygiel,

Yes.  You've got a point. Summarize & Filter is all that's needed.