Challenge #11: Identify Logical Groups

[PaulN]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[rslopez2]

Pretty similar approach to many others. Although, after reviewing some solutions it is clear that I definitely could have used less steps! 

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Johnny_Analytics]

Spoiler

I solved both with and without a macro.

[DanielMS]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[pharaphoks]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[David-Carnes]

I went back to my pre-Alteryx days and came up with solution that used few tools but necessitated a hard-coded list of Search/Bucket pairs.   But I like making solutions that are repeatable with different data sets, so I attempted to create a macro.  My mistake was attempting to duplicate my hard-coded solution rather than start fresh.

The posted challenge_11_solution_1.yxzp file contains a macro that utilizes a tool that I do not need to use often my daily work.  That macro is awesome but the solution had tools on either side of the macro to get it to the point of returning the expected data.  I copied that macro and nested it inside of a standard macro.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ExploreMore]

My Solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[LukeG]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[RotesDB]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Reesetrain2]

All,

My submission is attached.

-I used crossTab and Append Fields and the Formula to search for the Words after cleaning up the punctuation.

Spoiler

-Cheers!

Matt

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.