Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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
Started off well then made a right mess in the middle. Please ignore the unnecesary extra join tools 😄. Fun challenge, here's my solution:
This took me longer than I care to admit. Mostly because I point blank refuse to read the question.
Spoiler
First I used the text to columns tool to split out the first field on Input 2. I then dynamically renamed to take the name of the columns from the first row of data, then dropped the extraneous columns.
On Input 1 I stripped the commas from the number field and converted to a numeric value, then joined the two datasets together.
From there it was a simple task of Averaging each state and joining it back to the main stream and calculating the difference between this and the State value. I then isolated the min and max using the sample tool and joined them together.
First I used the text to columns tool to split out the first field on Input 2. I then dynamically renamed to take the name of the columns from the first row of data, then dropped the extraneous columns.
On Input 1 I stripped the commas from the number field and converted to a numeric value, then joined the two datasets together.
From there it was a simple task of Averaging each state and joining it back to the main stream and calculating the difference between this and the State value. I then isolated the min and max using the sample tool and joined them together.
Allegedly reading the question helps. The jury is still out.
M.
