Challenge #11: Identify Logical Groups

[Loic]

My solution - similar to others.

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

[joemkcarr]

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

[PeterGoldey]

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

[john_miller9]

Solution below, relying heavily on the Transform category (Crosstab, Transpose, Summarize)

Spoiler

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

[keng]

Used Data Cleansing to get rid of punctuation. I also didn't know the summarize tool could do a concat. 

Not sure how the macro works, but would be cool to eventually see how that was built out and the logic behind it. 

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

[Inactive User]

Hi - Attached is a solution to the task at hand.

Thanks!

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

[nickjastrzebski]

Took me a few attempts before I realised how important adding a RecordID at the start was.

Spoiler

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

[Hannah_Lissaman]

My solution 🙂

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

[phottovy]

My solution below.

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

[Greg_Murray]

Solution attached

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