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 #215: Gotta Catch 'em All!

Highlighted
11 - Bolide

What great practice with checkboxes!

 

Workflow

Spoiler
kayers_0-1590549422133.png

 

Interface

Spoiler
kayers_1-1590549453995.png

 

Highlighted
13 - Pulsar

Used chained apps to make the Interface tools dynamic with changes in the data.  Can't catch 'em all unless you have the entire list - which if you want there are several accessible databases out there!

 

Spoiler
215 Result.png

 

Workflow 215 Part 1.png

 

Workflow 215 Part 2.png

 

Highlighted
8 - Asteroid
Spoiler
jonathangonzales_0-1590598546071.png

 

Spoiler
 
Highlighted
7 - Meteor

Completed

Spoiler

NapasornCh_2-1590955005480.png

 

NapasornCh_0-1590954992334.png

 

Highlighted
Alteryx Certified Partner

Kind of rusty in the app making, but it is a good thing you can debug those things

 

Spoiler
Here is what my Workflow ended up looking like
The WorkflowThe Workflow


This results in an app looking like this: 

The AppThe App

 And with the settings above, the result looks like this:

The ResultThe Result

 

Still Climbing
/Verakso

 

Highlighted
8 - Asteroid

My solution attached

Highlighted
Alteryx
Alteryx

There are a couple of interesting things at play here when building this solution.

  • Firstly, configuring the List Box tool to generate a list, rather then the Select Tool mode. The List Box tool has 2 distinct functions it can be used for depending on the Use case.
  • Secondly, connecting "standard" tools to interface tools will not dynamically change the interface tool when the data changes. When you run the workflow in Designer, the Alteryx workflow stores the Metadata after the Crosstab and so that can then be used to configure the interface tool, however if that incoming data changes, the interface tool will not be updated unless you run the app as a workflow before loading the interface.
    • In short, the interface tools are configured by the GUI, the "standard" Tools will not execute until the AlteryxEngine runs, so the interface tools won't know the output of those until we hit run, and hence can only go off the stored metadata.

 

Spoiler
I chose to lay out the solution rather than combining Filters etc. I'm also a big fan of the Detour and I think it makes the solution a lot easier to debug/understand later.

Challenge215.png

 

 

Highlighted
Alteryx Partner

I love programming apps!

 

Spoiler
JustinBabbitt_0-1591212121486.png

 

Highlighted
8 - Asteroid

never tried the interface before that was nice..

 

 

Alteryx Certified Partner

My solution

 

Spoiler
challenge_215.PNG
Spoiler
challenge_215_1.PNG
Spoiler
challenge_215_2.PNG