cancel
Showing results for
Did you mean:
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.
Getting started with Designer? | Start your journey with our new Learning Path!

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

Asteroid

I chose the easy path!  My solution:

Spoiler
Alteryx Certified Partner

I took the easy route! :)

Highlighted
Asteroid

Went with the easy way first..

Spoiler
Meteor

This looks hard-path compliant?

Atom

Went the hard route without using a macro... Because apparently I enjoy pain...

But at least I ended up with a nice art piece! :P

Spoiler
Wish I knew about the Arrange tool before I created my waterfall of Selects...

Meteoroid

Nice challenge, so glad we have join, transpose and the multi-tools!

Spoiler
Nebula

Although I didn't include a piggy-bank icon - solution is similar to NJ's ( @NicoleJohnson ), but did do both an easy and hard solution for the exercise.

Spoiler

Enjoyed the two-macro solution posted by @cgoodman3  - didn't think of using 2 inputs to simplify; and the way that @JoBen used the dynamic select to only pick the first column in iterations

@GarthMiles & @patrick_digan have inspired me to go back and redo with the dynamic replace now - same with @EstherB47 and @Joe_Mako  and @ggruccio with the arrange tool.

My solution below:
The simple version

Nebula

Great challenge!

Thinking outside the Transpose/Join/Crosstab box was fun.  Though I avoided the Find Replace cause I think of it as a join tool now!

Spoiler
Slightly different from most.  Used a batch macro to process the company columns in turn and summed the results

MainMacro

Dan

Asteroid

Here is my "hard" solution...

Did not use the mentionned tools

Meteor

I'm not quite convinced I did the difficult way quite as intended, but I've also not made much use of the Dynamic Replace tool before!

Spoiler