Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
I like how the input data is a separate file as it:
1) checks users know how to read in different delimited files
2) As users are likely to save the input file to the same location as the workflow then it makes viewing other people's solutions a bit easier compared to when the files are packaged up.
Here's my solution:
1) checks users know how to read in different delimited files
2) As users are likely to save the input file to the same location as the workflow then it makes viewing other people's solutions a bit easier compared to when the files are packaged up.
Here's my solution:
I do love the weekly challenges, and here is my solution
Spoiler
This is a nice "beginner" task, since you will need to import the CSV file yourself.
Meaning, finding the right tool and the import a ANSI file that has tab as delimiter (\t).
Settings
Workflow
Meaning, finding the right tool and the import a ANSI file that has tab as delimiter (\t).
SettingsI am not sure if it is "cheating" to use the Formula tool, but the winner can be determined using a formula like this:
Winner = IF [score_i]>[score_j] THEN [Team_i] ELSEIF [score_i]<[score_j] THEN [Team_j] ELSE Null() ENDIFThe is was just a matter on do a Count NonNull's on the result, sort and pick the fist record
Workflow
That is how I matched the provided result
Still Climbing
/Verakso
