Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
8 - Asteroid

 

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
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed did it the hard way.

Highlighted
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

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My way below,

 

Spoiler
Challenge 142 - Capture.PNG
Highlighted
8 - Asteroid

Solution attached.

Highlighted
Alteryx Partner
Spoiler
WC_142.PNG

my easy solution

Highlighted
Alteryx Partner
 
Highlighted
12 - Quasar

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

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

 

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
My solutionMy solution
The tool takes three parameters
ParametersParameters

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 

Highlighted
7 - Meteor

My solution to this weeks challenge!