alteryx Community

# Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

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

10 - Fireball

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

Spoiler

14 - Magnetar

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!
10 - Fireball

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

10 - Fireball

@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 Alumni (Retired)

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

10 - Fireball

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