Compare rows

[wonka1234]

Hi,

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

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" .

[Luke_C]

Hi @wonka1234 

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

[Kakuffo]

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