Compare rows
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wonka1234
10 - Fireball
‎10-03-2022
10:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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" .
Labels:
- Labels:
- Custom Tools
2 REPLIES 2
17 - Castor
‎10-03-2022
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wonka1234
What fields are you joining on? Can you share some sample data and what your desired output looks like?
Alteryx
‎10-03-2022
12:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)