Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #11: Identify Logical Groups

Highlighted
Alteryx Certified Partner

That was a tough one... Got there in the end with a little glance at the soln. Two issues I had:

  1. Struggled to get my macro to output the Bucket field and not the Search field. Any guidance on this? Seems like an unnecessary join in the middle. I'd like this file's output but without using the extra join ideally. 
  2. Is there a better way of not truncating the Test2.csv fields without setting the length in the input to be 1000000? Seems overkill but I guess if that's the max length then there's no way around this. 

Interested to hear others' perspectives on this.

 

Thanks!


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

Highlighted
16 - Nebula
16 - Nebula

@MaxGiegerich 

 


@MaxGiegerich wrote:

 

  1. Struggled to get my macro to output the Bucket field and not the Search field. Any guidance on this? Seems like an unnecessary join in the middle. I'd like this file's output but without using the extra join ideally. 

 I think you can change your find replace in your macro to append whichever field(s) you would like. You could send both fields out of your macro like this:

Capture.PNG

 


@MaxGiegerich wrote:

2. Is there a better way of not truncating the Test2.csv fields without setting the length in the input to be 1000000? Seems overkill but I guess if that's the max length then there's no way around this. 

 


Not that I know of! You wouldn't have the length problem if you stuck with a yxdb file.

Highlighted
Alteryx Certified Partner
Spoiler

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

Highlighted
7 - Meteor

After fighting my urge to merge the two data sets in a futile and sad way, I stumbled into the Append Fields solution and then found that I'd literally copied another solution! So, I learned two things: how to make Append Fields work to my advantage and that I was on the right track with this. Again, an incredibly fun challenge.

Spoiler

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

Highlighted
12 - Quasar

Real excited to have used the append solution in this one. I do wonder if there is a more elegant way to solve it.


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

Highlighted
7 - Meteor

Hi,

     I have solved the challenge and the attached workflow runs in 1.5 Seconds.

 

Regards,

Naveen.


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

Highlighted
Alteryx Partner

Not the fastest workflow ever, but it works...


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

10 - Fireball

I will always accept parsing challenges!! 


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

Highlighted
8 - Asteroid

I got lazy and just hand coded the search/bucket info.


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

Highlighted
12 - Quasar
12 - Quasar

Learning more about regex all the time!  Had just learned about the summarize concatenate functionality a few weeks back, so that part was fairly simple.  Packaged due to the size of the input.


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