Alteryx Designer Desktop Discussions

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

Compare rows

wonka1234
10 - Fireball

Hi,

 

I am trying to compare rows after joining data (2 columns each)

 

wonka1234_0-1664819428447.png

However they are not in order, I tried using SORT to order them but doesnt work...

 

I do a formula on this :

 

CHECK = IF Acc ID = ACc id AND domain = Domain2 then "Same Access" Else "New Access".

 

Then Filter for "New Access".

 

How can I do this properly? The above photo should fall for "SAME access" .

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @wonka1234 

 

What fields are you joining on? Can you share some sample data and what your desired output looks like?

Kakuffo
Alteryx
Alteryx

You pretty much have it just need to finish the expression

 

Field NAme
Access:

 

 IF [*_Acc ID] =  [****_Acc id] AND [domain] = [Domain2] then "Same Access" Else "New Access" endif

 

Then as a next step you filter on the Access column

 

Labels
Top Solution Authors