Challenge #358: Goodbye, Michael! (Part 1)

[SammiJohnson]

My Solution 🙂

[robert-headington]

#358

[martinson]

Attempt 1 using data cleansing tool. Investigate alternatives in future.

[martinson]

Attempt 2 using formula tool and regex over data cleansing. Much faster. Regex over text to column would be beneficial.

[cmoussa]

[griffinwelsh]

My solution

[Suresh_batchu]

Solved !!

Spoiler

[blairmbailey]

Solution attached! Slightly different counts than the provided output, but looks like others ended up with the same. Thanks!

[JBevan89]

Solution attached

[mwong]

I was not a fan of this challenge.  But maybe this was a lesson that I pay a lot of attention to data quality, more than the average Alteryx user / more than is needed for certain objectives (I did not know how to handle / I assumed we should be considering typos).  After extensive review of the solution and the details between my solution and the published solution, I determined that differences were immaterial and depend on the specific situation / ask.