Introducing SOC Insights for BloxOne Threat Defense: Boost your SOC efficiency with AI-driven insights to eliminate manual work and accelerate investigation and response times. Read the blog announcement here.

Network Change & Configuration Management

Reply

Alteryx Designer vs MS SQL Server aggregation differences

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

Superuser
Posts: 115
1696     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
1696     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