Are you interested in our Early Access Program (EAP)? This program allows you to preview code, test in your lab and provide feedback prior to General Availability (GA) release of all Infoblox products. If so, please click the link here.

Network Change & Configuration Management


Alteryx Designer vs MS SQL Server aggregation differences

[ Edited ]
Posts: 1
1199     0

I am working on converting a data pipeline that runs on Alteryx Designer into a MS SQL Server query, and I am noticing that I get different results when I use the GROUP BY step. For example, both processes read from the same table that has 2,318,794 rows, but when I use aggregate functions (GROUP BY, MAX(), COUNT() and SUM()) they Alteryx process returns 2,089,738 rowsand the SQL query returns 2,089,238 (a 500 row difference) and the difference increases the more I aggregate, to the point that by the end of the process I end with a 60k lines difference between what  Alteryx returns and what my query returns.

Is there a difference on how Alteryx and MS SQL Server execute aggreation operations? Or how they handle NULL values when aggregating?

Any input or idea is appreciated, thank you.

An experienced self-starter, avid learner and problem solver,
working as an Application Developer at Course Drill.

Re: Alteryx Designer vs MS SQL Server aggregation differences

Posts: 115
1199     0

Is this for the NetMRI SQL database access?

Follow me on LinkedIn:

Re: Alteryx Designer vs MS SQL Server aggregation differences

New Member
Posts: 1
1199     0
But one thing you must understand, is that SQL apply rules about some datatypes that can be different in other systems. I do not know what Alteryx Designer is, but, as an SQL expert and formerly a SQL Server MVP, I suspect this product to not conforms to the standard ISO SQL.
Showing results for 
Search instead for 
Did you mean: 

Recommended for You