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

[DataPrepChad]

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

Spoiler

[Ladarthur]

Hi,

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

[kat]

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

Spoiler

batch macro to the rescue!

[DataPrepChad]

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

[SamDesk]

Just the easy way for now

Spoiler

[GarthMiles]

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.

[DataPrepChad]

@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

[JoeM]

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

[TylerNa]

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

[GarthMiles]

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