Challenge #224: Mushroom for Improvement

[bsanders2009]

This is a great example of one of those problems that conceptually is easy to pick up and a little trickier (for me at least) to solve!

Spoiler

[TonyA]

I feel like I could have done this with less tools. I did add a bit to make sure the column names matched the original format rather than forced to underlines.

Spoiler

[bjkay30]

A similar approach to most of the others.

Spoiler

[ggruccio]

I always think I will use find and replace, but often use join for these kinds of exercises....The 'missing' threw me for a minute!!!

Spoiler

[LHolmes]

This was a great exercise in foraging for parsing tools, configurations, and formulas. 

***UPDATE*** After posting my solution and browsing through others I came across one with a tool I have not used before - so decided to dig in, looked at the Alteryx embedded examples, and !POOF! a new solution. Tool reveal and updated (slightly more elegant) visual in spoiler, along with new .yxzp.

🙂

Spoiler

Workflow

Discovering the Dynamic Replace tool... so cool! Mushroom data set needs no transformation, only need to create a boolean field for the replace ([_CurrentField_]='[code field]'. Field Name Field uses the parsed field names from second input as the index, with boolean logic, to replace with description.

With alternate Dyanamic Replace solution.

[DaisukeTsuchiya]

It was fun challenge!

Spoiler

[JustinBabbitt]

Fun Challenge!  Not my best documentation this time, but... I'm on vacation.  😃

[Inactive User]

This is a bit of challenging for me.

Spoiler

[AkimasaKajitani]

My Solution.

Spoiler

 

[szade1]

Here's my solution... Bit messy but got the results.