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.
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.