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

Solution

Spoiler
Spoiler

Workflow.PNG

 

Alteryx Partner

Solution (easy path)

 

Spoiler
Screenshot_1.jpg
Asteroid
 
Alteryx Certified Partner
Spoiler
I took the hard path using 2 batch macros.
One macro uses a Dynamic Select to union all records into 2 columns, then a second to apply a formula with an IF statement that I modified with an XML update from the IF conditions.
Asteroid

Use the easy, no idea for hard way by myself will learn from it

Spoiler
Spoiler:
142.PNG

Solved by the hard way, unfortunately.

This was the hardest for me until now.

Spoiler
142.png

Nice exercise.

Cheers!

Antonio Alves

 

 

 

Meteoroid

My solution: 

Bolide

My attempt at the hard path:

 

Spoiler
The hard path took my brain out of the box on this one. I had the idea of creating a conditional formula based on the Tax Table with a Summarize tool concatenation and passing it into a macro to test the sample values.

Capture.PNG


Capture.PNG

I couldn't get rid of the Transpose tool in the macro and have to give up for the moment due to real life Alteryxing that must be done.

Thanks for the brain break, and I'm glad we get to use all the Alteryx tools in real life!