The Weekly Challenge Program is evolving! We’re creating a better, more modern experience designed around how our community learns and practices today, with a refreshed program launching soon. Stay tuned!
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.
