SSO Login is being implemented on this site. Existing users: Your existing password must be reset the first time you login using SSO. Click here to reset your password first before login. Your new username will be your email.

Network Change & Configuration Management

Reply

Alteryx Designer vs MS SQL Server aggregation differences

[ Edited ]
Member
Posts: 1
649     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

Adviser
Posts: 113
650     0

Is this for the NetMRI SQL database access?

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

https://sifbaksh.com

Re: Alteryx Designer vs MS SQL Server aggregation differences

New Member
Posts: 1
650     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