We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Compare Data on Column

fjlorenzo
8 - Asteroid
‎03-11-2025 10:19 AM

I have the below data in Excel that I need to compare. How can I easily check which role only has System1?

 

RolenameAccess
Role1System1
Role1System2
Role2System1
Role2System1
Role3System1
Role3System3
Labels:
Reply
0 Likes
2 REPLIES 2
griffinwelsh
12 - Quasar
‎03-11-2025 10:28 AM

@fjlorenzo you can do this with a filter and a join tool. I've attached a sample workflow for you. Please mark the thread solved if this met your needs.

Find role with one system.yxmd
Reply
0 Likes
fjlorenzo
8 - Asteroid
‎03-11-2025 10:33 AM

Great thanks @griffinwelsh 

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All