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.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

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

9 - Comet

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

Spoiler

13 - Pulsar

Hi,

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

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!
9 - Comet

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

11 - Bolide

Just the easy way for now

Spoiler
7 - Meteor
Spoiler

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.

9 - Comet

@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
Alteryx Community Team

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

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