community
cancel
Showing results for 
Search instead 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.

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

Meteor

I chose the easy path!  My solution:

Spoiler
142 EW.PNG
Alteryx Certified Partner

I took the easy route! :)

Asteroid

Went with the easy way first.. 

 

Spoiler
Challenge_142_Spoiler.JPG
Meteor

This looks hard-path compliant?

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

Challenge142.PNG
Meteoroid

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

 

Spoiler
solution.png
Aurora
Aurora

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:
SimpleSolution.jpgThe simple version

Annotation 2018-11-22 110756.jpgAnnotation 2018-11-22 110825.jpg

 

Quasar

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

main.pngMainTXRate Macro.pngMacro

 

 

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