Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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


This one took me quite a while! And it would have been so simple to take the easy path...
Thanks for the challenge!


Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed did it the hard way.

Alteryx Certified Partner

Here's my solution.


Screenshot 2018-12-29 at 22.24.34.pngScreenshot 2018-12-29 at 22.24.40.png



Alteryx Certified Partner

My way below,


Challenge 142 - Capture.PNG

Solution attached.

Alteryx Partner

my easy solution

Alteryx Partner

easy route. I don't have the brain power right now for the hard one!

Alteryx Certified Partner

So this was an easy one Huh?


Well not for me, I first tried the Macro way but gave up, it was still to advanced for me.


Since I have literally spent weeks (well on and off),  I could see where @JoeM want us to go, so thanks for pushing us to learn a new tool.


I do not think it is too much a spoiler to write Dynamic Replace, since it at least to me, was a bit tricky to learn.

The built in help wasn't much help to me, but luckily we do have the Tool Mastery | Dynamic Replace.

After reading that (several times. before I finally understood this tool) I was able to provide the solution.


And I must admit, that the Dynamic Replace is a nifty tool, and especially for this task, so once again - thanks again to 

@JoeM for pushing me in that direction.



As I have stated, after I had read the Tool Mastery | Dynamic Replace a couple of times, I began to get an conceptual understanding on how this tool works, and here is my short interpretation
2019-01-10 11_34_30-Alteryx Designer x64 - challenge_142_verakso.yxmd.pngMy solution
The tool takes three parameters
2019-01-10 12_28_36-Alteryx Designer x64 - challenge_142_verakso.yxmd.pngParameters

The first is the field name that you would like to replace
The second is the boolean expression that you wish to check for.
And the third is the value that in case the boolean expression is valid is substituted with

Now the "tricky" part is how to write that boolean expression, and it took me a couple of attempts to get it working, so do not despair

Try and try again - I did, and did learn something new on the way.


Until next time



My solution to this weeks challenge!