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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

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!

 

Spoiler
AWC_142.PNG
Asteroid

Challenge Completed did it the hard way.

Alteryx Certified Partner

Here's my solution.

 

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

 

 

Alteryx Certified Partner

My way below,

 

Spoiler
Challenge 142 - Capture.PNG
Asteroid

Solution attached.

Alteryx Partner
Spoiler
WC_142.PNG

my easy solution

Alteryx Partner
 
Quasar

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

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

 

Spoiler

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

/Thomas 

Meteor

My solution to this weeks challenge!