community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

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

Alteryx
Alteryx

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.

Asteroid
 
Meteoroid

Here's my easy solution.

Highlighted
Asteroid

My solution attached. Took the harder route by coincidence.

Asteroid
 
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

Meteor

Easy path for me this time!

Spoiler
142_BW.PNG
Asteroid

Easy path.

Pulsar
Pulsar
Spoiler
Trying to get through this back log of challenges so just went the simple route for now!

Capture.PNG
Alteryx
Alteryx

My solution: