Challenge #215: Gotta Catch 'em All!

A solution to last week’s challenge can be found here.Source: https://en.wikipedia.org/wiki/Pokémon

With over 800 Pokemon in existence, avid Pokemon fans could use some help figuring out what Pokemon are available for their them to use on their teams. Build an Alteryx App that helps sort through the options.

Configure the App's interface tools to use a List Box for the Regions, a Dropdown tool for the type, a Check Box tool that allows legendary Pokemon, and a Check Box tool that removes regional variants of the same Pokemon.

Once configured let us know how many Ghost Type Pokemon are in the Alola, Galar, Johto and Kanto regions with Legendary and Regional variants allowed!

challenge_215_start_file.yxmd

challenge_215_solution.yxzp

Apps

Preparation

Advanced

Intermediate

Transform

Interface

Accepted answers

All comments

philipmannering

App attached.

Can somebody explain when you should use the thunderbolt and when to use the Q anchor?

Spoiler

App App

challenge_215_start_file.yxwz

Aaron_Harter

User Interface:

Spoiler

Workflow:

Spoiler

challenge_215_AB Data Consulting_Aaron.yxwz

johnemery

Cool challenge. I don't make a ton of apps, so these are always good practice.

Spoiler

Watch my solution video here:

Spoiler

Challenge 215 Solution jemery.yxwz

Blake

Fun to make an app on Monday Morning!

Spoiler

challenge_215_start_file_BH.yxwz

NicoleJohnson

My solution!

Spoiler

Cheers!

challenge_215_NicoleJohnson.yxwz

patrick_digan

Spoiler

1) I like using reference shortcuts in my filter as it makes it easier to test/debug. I just use Control + R to run it like normal and can change test values on the Workflow tab.
2) Sorry for tooting my own horn, but I have some ideas that would make working with interface tools better/easier
a) Data from Connected Tool option - why should I have to crosstab my data? Adding "data from connected Tool" to the dropdown/listbox could allow you to go straight from the summarize tool to the interface tools.
b) 2 small changes - Why can't I change the name of the question in the workflow tab and change my test value in the tool itself?
c) Let Question constants be used like other constants - Why can't I just reference my questions like [Question.Region]? It works for User Constants, so I think it would be great if they added if for Question Constants. The one drawback of using reference shortcuts is that you have to know the syntax, so letting questions behave like normal fields would remove that.

challenge_215_start_file.yxwz

dsmdavid

Spoiler

david_215.yxzp

Victor_Mendes

I just love the interface tools!!! Cool challenge

Spoiler

challenge_215_Victor_Mendes.yxwz

Victor_Mendes

When you use the "Q" anchor, you can reference the connection inside your tool the one with the "Q" connection.

And when you use the thunderbolt you create your Fórmula inside the Action tool

Fórmula tool with "Q" Anchor

Formula tool with Thunderbolt, the [#1] doesn't exists

balajilolla

Spoiler

Solution Attached

challenge_215_start_file.yxzp

Kenda

Spoiler

challenge_215_start_file.yxwz

atcodedog05

Gotta Catch 'em All!

Man!! i used to love that show. This takes me back to my childhood : )

Spoiler

Here is my approach.

Happy analyzing : )

challenge_215_atcodedog05_Solution.yxmd

RolandSchubert

My solution.

User Interface:

Spoiler

Workflow:

Spoiler

challenge_215_solution_rsc.yxwz

Did anyone else use Detours for the two checkboxes?

Spoiler

challenge_215_mj_solution.yxwz

Jonathan-Sherman

Challenge 215 is done!

Spoiler

challenge_215_JMS_solution.yxwz

ponraj

Here is my solution

Spoiler

challenge_215_solution.yxwz

TonyA

I learned a lot more than I expected to from this week's challenge. Thanks to @NicoleJohnson and @Victor_Mendes for the lessons on using the Q anchor and @patrick_digan 's explanation of reference shortcuts.

Spoiler

I took the long way using detour tools and multiple filters, but now I have a lot more options!

challenge_215_TonyA.yxmd

abrouwer

Please find my solution attached.

Spoiler

challenge_215_solution_file - AJB.yxwz

patrick_digan

@MJ wrote:
Did anyone else use Detours for the two checkboxes?

@MJ

I tried the detour tool several years back when I was just learning alteryx and I was having trouble getting it to work. It looks so simple, but after that experience I gave up on the tool and have refused to go back and try it. Everyone makes it look so easy (as I'm sure it is), but I guess I just can't give up that grudge 🙂

AngelosPachis

My solution for challenge #215

Workflow:

Spoiler

Interface & Results

Spoiler

challenge_215_solved_AP.yxwz

bsanders2009

This was my first real app. Thanks for the challenge that forced me to figure this out!

Spoiler

challenge_215_finished.yxwz

kelvin_law1

Here is my solution with the result:

Spoiler

challenge_215_solutions.yxwz

jasperlch

Spoiler

challenge_215_JL.yxwz

LorenzoDB_dup_193

Hi,

App attached and this is my workflow:

Spoiler

Bye

Lorenzo

Challenge #215 - Solution - LDB Scai Finance.yxwz

Ladarthure

My solution!

challenge_215_start_file.yxwz

JohanRanschaert

Spoiler

challenge_215_solution_JR.yxwz

huynv96

Done! Thanks

Spoiler

challenge_215_huynv96.yxzp

OllieClarke

Yay Pokemon!

Spoiler

App

Interface

challenge_215_OC_solution.yxwz

Jean-Balteryx

Here is my solution !

challenge_215_workflow.yxwz

freewind

Spoiler

Interesting one.. have a good review of interface tools and formulas

challenge_215_start_file_Autosave.yxwz

uday1610

Using Interface tools is great in alteryx workflow.

challenge_215_start_file.yxwz

FlorianC

Such a good subject!

Spoiler

Challenge #215.yxzp

ggruccio

Fun challenge!

Spoiler

challenge_215_gg_finish.yxwz

deepaprash

Q is like a "Question" that can be connected to a tool that has an expression builder. So tools like formula, filter etc will have the Q attached to it.

When you connect the 2 Q's the actual expression or 'question' gets passed onto the workflow and not the selected or resulting data. For example, if you had a filter tool in your workflow and were filtering for a value 'Legendary', you could run the workflow and get results with 'Legendary' in it. However, when you connect the Q's, the expression for filtering gets added to the workflow and you cant run the workflow anymore to get the same results as before. Hence, de-bugging becomes harder. If you were to instead connect to the lightening bolt, you could still run the workflow and get the results as before. This is one of the major advantages of connecting to the lightening bolt.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280