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

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
2 REPLIES 2
griffinwelsh
12 - Quasar

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

fjlorenzo
8 - Asteroid

Great thanks @griffinwelsh 

Labels
Top Solution Authors