Challenge #11: Identify Logical Groups

[qb]

Far far FAR too many tools used. I am still fighting the urge to re-do it "perfectly", and just accept that I am a newbie who is growing, and a bunch of big finished messes are much better than nitpicking over one unfinished beauty.

I had an issue where Alteryx insisted on automatically truncating fields like "Screen,Tones" into "Screen". I tried to figure out why, but eventually settled on creating a numerical field instead and adding the text later.

I labelled everything so it would be clear to future me. 😛 Pardon the mess.

Spoiler

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

[TimothyManning]

Spoiler

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

[Marcel_Gavrila]

Here's my solution!

Spoiler

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

[alexo]

I spent a long time trying to automate the generation of permutations, but ended up just hardcoding them as it massively simplified the workflow. An append fields + formula to find matches runs in under five seconds.

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

[fmeo]

Révélation

[MattBenj]

Solution attached.

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

[Mike_Hinz]

Spoiler

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

[sara-hamdoun]

Révélation

Spoiler

[Nikos_I]

Dear Team,

I cannot post my solution I keep receiving the following message when I press to Reply.

Thank you,

Maximum size: 66 MB • Maximum attachments allowed: 7

The maximum number of attachments has been reached. Maximum number of attachments allowed is: {0}

[justindavis]

First intermediate challenge after many of the beginner ones completed. Is there a better way to compare performance across two versions of your workflow than just runtime? For example in SQL you can check CPU, logical reads, etc.  I tried...

Spoiler

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