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.

Checking if minimums belong to the same record

Dennis229
7 - Meteor

Hey there.

I have a specific problem that I managed to solve but my approach isn't scalable if more data with additional rounds (laps) was captured. 

I was unable to come up with a tool that reaches a solution in a simple but efficient way. 

 

I want to check if the minimum finish time in each round and in the complete contest belongs to the same person, keeping in mind that I want this workflow to function even when more rounds are added in future data collection. 

2 REPLIES 2
binuacs
21 - Polaris

@Dennis229 I tried to make it dynamic, but can you test it with a few more rounds?

 

binuacs_0-1673819400550.png

 

RobertOdera
13 - Pulsar

Hi, @Dennis229 

 

Please see the below.

All your fields, e.g., winner ID, round ID, #wins, and #rounds, should autogenerate, tally, and give you a status update as you add rounds.

 

Please mark it as an acceptable solution if it works for you.

Cheers!

 

TestForDennis229.PNG

Labels
Top Solution Authors