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

Not sure I'd call this the "easy" way, but great challenge!

Spoiler
Spoiler_142.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

funny one, wanted to go the easy way first but ended up doing it the hard way :)

Highlighted
12 - Quasar

Looks like @NicoleJohnson and I had very similar thinking here. Eliminating certain tools gives things an interesting spin.. :)

 

Spoiler
batch macro to the rescue!batch macro to the rescue!Challenge #142.PNG
Highlighted
Alteryx Certified Partner

@ggruccio I like what you did with the concat, gives me an idea!

11 - Bolide

Just the easy way for now

Spoiler
Capture.PNG
Highlighted
7 - Meteor
Spoiler
Screen Shot 2018-11-19 at 3.24.37 PM.png
Given the "Hard Way" constraint, Dynamic Replace is arguably the best straight-line approach here. However, if comprehension were a measure, Dynamic Replace is second to none in complicating the simple.

 

Highlighted
Alteryx Certified Partner

@JoeM I think I know where you were going with introducing a new tool.  I couldn't help myself, Dynamic Replace to the rescue. 

Spoiler
Spoiler_142 Hard.png
Highlighted
Director, Customer Enablement
Director, Customer Enablement

@GarthMiles @DataPrepChad, you guys went the direction I was hoping to see someone try out! Lots of variety this week!

Highlighted
9 - Comet

Finally used a tool that I've seen a ton but haven't had the opportunity to use. Made the hard way quite a bit easier!

Spoiler
Arrange Tool FTWArrange Tool FTW
Highlighted
7 - Meteor

Ugh, @JoeM...I loathe the Dynamic Replace tool (mostly 'cuz I still need the help doc to guide me through setting it up).

 

The best advice I ever received for configuring this tool is to write out the "Boolean" and "Output" expressions in 2 (or more) Multi-Field Formula tools (1 expression per "multi-field" tool) to check that the syntax+logic make sense.

 

Then...copy/paste those expressions into a Formula tool (1 for "boolean", 1 for "output", etc.) and wrap'em in quotes.

 

Once everything works as expected...run garbage collection (i.e., delete all multi-field tools from canvas) and pretend you worked through it all in your head!!