Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Only filter 'keys' with multiple a car purchase and at least one service

OwaisYounus
6 - Meteoroid

Hi 

 

I have a data with 3 columns i.e Key, date and Service. I am trying to filter the keys that has Car purchase and at least one service. Looking for help. Thanks

 

1.JPG

4 REPLIES 4
suby
11 - Bolide

Hi,

 

Can you post the Data rather than copying it.

It will make easier for the experts in the forum.

 

Thanks

Qiu
20 - Arcturus
20 - Arcturus

@OwaisYounus 
The data would be much better.
below is one sample.
We can concantate the "Service" then do a filtering as below.

0812-OwaisYounus.PNG

OwaisYounus
6 - Meteoroid

Thanks for the quick responses. Here's the data as requested.

OwaisYounus
6 - Meteoroid

Here's the data

Labels