Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #115: Let's get crafty!

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
This is my solution

atcodedog05_2-1585837637641.png

 


atcodedog05_0-1585837583615.pngatcodedog05_1-1585837604458.png

 

dashakir1
8 - Asteroid

Thanks.

AndrewS
11 - Bolide

#115

Spoiler
115.PNG
alexnajm
16 - Nebula
16 - Nebula

Done!

LHolmes
9 - Comet

Great followup to some Analytic Apps training! Instead of output to browse this solution generates a PDF report.

 

Spoiler
115 - Solution.PNG
izamryan
8 - Asteroid

Hiya @patrick_digan !

Your solution looks great, it's so simple!

 

Spoiler
izamryan_0-1590586436544.png
But how do you get the Browse tool to display the results of the filter? I tried to replicate the same but my Browse tool keeps coming up with zero results.

I thought there might have been a wireless connection somewhere, but I went through all the tools and didn't see any!

 

 

 

 

izamryan
8 - Asteroid

Hi @ChristineB ! Not sure if this is an issue with my Alteryx install ...

... but the suggested solution for this challenge gives me a "There was no Output files" when I select the type of beer I want to drink?

 

izamryan_0-1590588047066.png

 

I must admit this particular Challenge has me stumped! Does anyone in the community want to jump on a Google Meet video call to try and solve this one together?

 

I think I half completed the Challenge, but I am having trouble with Browse tools being nested inside containers that are deselected. And I tried looking at some of the other solutions posted but some of them also suffer from this - "they don't show the beers" problem?

 

/shrug

 

 

patrick_digan
17 - Castor
17 - Castor

Hello @izamryan, glad you liked my solution! When you're using reference shortcuts, you can setup "test" values on the workflow - configuration >>> workflow tab so that way it should show some data in your browse tool. Note that if you copied my tools to another canvas, the interface tools will be named differently. You can rename them by clicking on each interface tool and then selection the annotation tab (4th one down) and typing in the Name field to match what I was using. In the below picture, I'm using Altbier as my test value and also marking the style box as selected (True) and the state box as unselected (false). Since the state box is false, I don't need to set a state test value. 

patrick_digan_0-1590604085844.png

 

patrick_digan
17 - Castor
17 - Castor

@izamryan as for your workflow, I think you were really close. Here are the changes I made:

 In the interface designer's properties, I checked both render tools. You may need to go to view >> interface designer to be able to see it the menu.

patrick_digan_0-1590605343803.png

 


I added 2 action tools to disable containers based on what boxes are checked. Note that I connected the style box to the state container so that it disables the state container when the style box is checked.

patrick_digan_1-1590605422503.png


I added a dynamic rename in the style container because it uses the field names which convert spaces and slashes to underscores. That was messing up the filter then.


I moved the drop down and action tools out of the containers as you will get an error if an interface tools are in disabled containers. 


I changed the join multiple in the state box to join based on record position.


I set the header to be the field called "header" on the state render tool. It was set to the layout by mistake.

AngelosPachis
16 - Nebula

My solution for challenge #115 

 

Spoiler
Annotation 2020-05-27 210550.png