Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Filter out data from one column based on values from another column

OwaisYounus
6 - Meteoroid

Hi,

 

I have two columns 'Name' and 'service'. I am trying to get an output only those names that has multiple services and exclude the names that has only 'Bike' value in it. Looking for help in what formula to use. Thanks

 

Attached is the dataset

 

3 REPLIES 3
Connect_Rehan
6 - Meteoroid

You can add filter tool and use this formula to separate out BIKE values and other values.

Connect_Rehan_0-1661724929813.png

OwaisYounus
6 - Meteoroid

Thank you

Connect_Rehan
6 - Meteoroid

Glad I could help...

Labels
Top Solution Authors