# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
10 - Fireball

I chose the easy path!  My solution:

Spoiler
Highlighted
Alteryx Certified Partner

I took the easy route! 🙂

Highlighted
8 - Asteroid

Went with the easy way first..

Spoiler
Highlighted
7 - Meteor

This looks hard-path compliant?

Highlighted
6 - Meteoroid

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

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

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

Highlighted
6 - Meteoroid

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

Spoiler
Highlighted
16 - 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

Highlighted
17 - Castor

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

Highlighted
8 - Asteroid

Here is my "hard" solution...

Did not use the mentionned tools

Highlighted
7 - 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