Keep first row of each duplicate row?

[Crispy131]

Hello,

I have data that looks like the following table. Note I've sorted the table by each column and the last column 'Number' in ascending order because I only want to keep that first number for every row where the year/month/country are the same. Basically like removing duplicates (excluding the Number column) and keeping the first row of each instance.

Year	Month	Country	Number
2021	MAY	USA	80
2021	MAY	USA	81
2022	FEB	ITALY	30
2022	FEB	ITALY	35
2022	DEC	GERMANY	115

So I want the output to look like this:

Year	Month	Country	Number
2021	MAY	USA	80
2022	FEB	ITALY	30
2022	DEC	GERMANY	115

any ideas please? I'm stuck after the sorting. 

Any help is much appreciated!

[Felipe_Ribeir0 · Accepted solution]

Hi @Crispy131 

The unique tool always keep the first row of the duplicated rows, so after sorting it, just use the unique tool selecting the correct columns and it will do the job.

Check out the official doc for more details about the unique tool: https://help.alteryx.com/20223/designer/unique-tool

[Crispy131]

Awesome! My first time using this tool thanks!