Free Trial

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
Top Solution Authors