Free Trial

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