This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
If you only have 4 fields, that should produce the same result. If you have more than 4 fields, the Summarize tool will drop the fields that aren't set as 'GroupBy', where the Unique tool will keep the first record for the remaining fields following the unique set.
A group by and the Unique operator as indeed very closely related, but different outcomes.
My attachment shows this, but the Unique tool actually performs something that would take several separate steps in SQL and would involve a Group By statement. Essentially a Distinct groups up by the columns you're using for distinctness, then joins back to the first record in the group to get the other columns.
The Summarize tool is the same concept as a Group By in SQL, without the join back.
So as you can see, in some instances they will yield the same result, but the tools' usefulness and raw capability are quite different.