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!
Solved! Go to 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
Awesome! My first time using this tool thanks!