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

Challenge #142: Life Certainties - Workflows, Death, and Taxes

TonyA
Alteryx Alumni (Retired)

Here's my solution. I realized where Joe wanted us to go early, but had a hard time figuring out how to get around using transpose to get all the numbers in one column and avoid a bunch of redundant calculations. Finally found a tool that did the job.

elliemason
8 - Asteroid
 
georgetardy
6 - Meteoroid

Here's my easy solution.

hbraunius
8 - Asteroid

My solution attached. Took the harder route by coincidence.

CRowlatt
8 - Asteroid
 
Sajeel_Kershi
8 - Asteroid

Transposed grid data to list; split out salary from I/J Flag

Cross tabbed the Rate table and then add multi row tool to add in from salary range (assumed that the salary in original table is the top level of that rate)

Cross product joined the above two (using the Append fields tool) and then applied formula to flag if row is in the salary range. Filtered out only valid Rates and then finish off with a summary tool to count for each rate and sorted descending. Did not use the company table as its not adding any value, if the table had another column with a meaningful company name then would use to join in or use replace tool

BradWerner
11 - Bolide

Easy path for me this time!

Spoiler
142_BW.PNG
MsBindy
8 - Asteroid

Easy path.

Kenda
16 - Nebula
16 - Nebula
Spoiler
Trying to get through this back log of challenges so just went the simple route for now!

Capture.PNG
DavidThorpe
Alteryx
Alteryx

My solution: