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.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

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

10 - Fireball

I chose the easy path!  My solution:

Spoiler
8 - Asteroid

I took the easy route! 🙂

8 - Asteroid

Went with the easy way first..

Spoiler
7 - Meteor

This looks hard-path compliant?

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

6 - Meteoroid

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

Spoiler
17 - Castor

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

18 - Pollux

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

Dan

8 - Asteroid

Here is my "hard" solution...

Did not use the mentionned tools

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