community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

return max rows

Highlighted
Asteroid

Hi everyone! I have the following problem - I need to find Preferred type based on the number of visits. E.g. if the visitor visited opera and ballet the same number of times than he prefers both - opera and ballet

 

VisitorType# of visits
User1Opera1
User1Ballet1
User2Opera

2

User2Ballet1
User2Concert2
User3Ballet 3

 

Output:

VisitorPreferred type
User1Opera
User1Ballet
User2Opera
User2Concert
User3Ballet 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hey @Nastya

 

Here's the solution that I thought.

 

return max rows.PNG

 

Cheers,

 

 

Quasar

Here is the sample workflow for your case. Hope this is helpful. 

 

workflow.PNGWorkflowResults.PNGResults

Labels