Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

realdaniel1989
8 - Asteroid

Solution

Spoiler
Spoiler

Workflow.PNG

 

yurii
8 - Asteroid

Solution (easy path)

 

Spoiler
Screenshot_1.jpg
Inactive User
Not applicable
 
CharlieS
17 - Castor
17 - Castor
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.
yajing_wang
8 - Asteroid

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

Spoiler
Spoiler:
142.PNG
AntonioGonzales
8 - Asteroid

Solved by the hard way, unfortunately.

This was the hardest for me until now.

Spoiler
142.png

Nice exercise.

Cheers!

Antonio Alves

 

 

 

calampert
7 - Meteor

My solution: 

ddiesel
13 - Pulsar
13 - Pulsar

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!

payam2
8 - Asteroid

My last one before Christmas. Have a great time everyone!

JackParry
8 - Asteroid

My solution, probably quite a long way around it, but it works