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

Highlighted
Alteryx Certified Partner

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

Spoiler
Spoiler_142.png

 

Quasar
Quasar

Hi,

 

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

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

Highlighted
Bolide

Just the easy way for now

Spoiler
Capture.PNG
Highlighted
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
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
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!!