Challenge #11: Identify Logical Groups

[RWvanLeeuwen]

only 3.4 seconds required to finish the flow!!

add ID field. cross-join using append field. filter on contains formula. summarize summarize

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

[ivoller]

I used the brute force and ignorance approach. If I was doing this for real, I'd use a macro.

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

[locunhalima]

My solution.

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

[joshuaburkhow]

I did all kinds of crazy on this one 😉

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

[dillon_bok]

Spoiler

[jsdeter]

Posting Solution

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

[JORGE4900]

Hello all,

I started taking a similar approach as @NicoleJohnson but switched track and did a long version of the macro. Comparing these two, Nicole's version runs much faster on my computer.

Spoiler

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

[ponraj]

Here is my version of my solution

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

[JDelgado]

Not up to speed on building macros yet, so I did not do that solution.

My solution seems kludge-y, but it gets me there. I spent a lot of time trying to make it dynamic; that is, have it identify buckets based on the contents of the second file that had the search terms and buckets. I was unsuccessful so had to go the hard-code route. If anyone knows if this is possible, please let me know and give me a hint how to do it.

Thanks!

JohnD

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

[daniel_ferreira]

Follow my solution attached...

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