In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Match, Count, and Filter?

sartol
7 - Meteor

I am new to Alteryx Designer

 

I want to:

check and see if the machine ID and the machine use time match             (I tried the Unique Tool but it doesn't work for this)

if so, count how many times a function is used (how many rows have: that function, that machine ID, and that use time)

filter out the rows with that function use below a certain threshold       (Could probably use the filter tool if I got to this step)

 

Is that possible? How to?

Thanks!!

 

 

 

3 REPLIES 3
dougperez
12 - Quasar

Use a summarize tool (se the workflow arrached) 

 

sartol
7 - Meteor

Yes! Then I used unique to remove the repeats from the data.

Thanks so much!

dougperez
12 - Quasar

You're welcome!

 

Mark the solution to help others too!

Labels
Top Solution Authors