Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unique row values in table

omar_velor
7 - Meteor

Hi all,

 

I want to get the unique values in a table considering all values in each row. Let me explain with a simple example:

 

Considering the table below,

 

IDCountryCity
AENLondon
BENLeeds
AENLondon
CENOxford
DENCambridge
BENLeeds
DENCambridge
AENLondon
EENLiverpool

 

How can I obtain the unique rows? The output should look like the table below,

 

IDCountryCity
AENLondon
BENLeeds
CENOxford
DENCambridge
EENLiverpool

 

Cheers!

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @omar_velor, you can use the Unique tool for this, selecting all columns like so:

 

9.png

omar_velor
7 - Meteor

Many thanks! I initially asked because I thought that I was not using the "Unique" tool properly. I then realised that the mistake was on my inputs.

Labels