Challenge #115: Let's get crafty!
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ChristineB
Alteryx Alumni (Retired)
05-07-2018
10:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A solution for last week's challenge has been posted here in both video and workflow forms!
This week's Challenge lets you get crafty! Create an app to allow a user to search a list of craft canned beers by state of origin or beer style. Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles. Feel free to customize the app as you see fit!
Labels:
- Labels:
- Advanced
- Apps
- Intermediate
- Join
- Preparation
- Transform
patrick_digan
17 - Castor
05-07-2018
11:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
You may have to run this as a workflow first to populate the drop downs. I love using the %Question.Name% syntax to pass variables. I used the dynamic rename because the crosstab goofs up fieldnames (changes spaced and special characters to underscore). If I'm allowed to toot my own horn, this challenge would have been easier if this idea or this idea were completed :)
kat
12 - Quasar
05-07-2018
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mmongeon
8 - Asteroid
05-07-2018
11:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my submission!
Spoiler
I would have prefered to have my Beer Style drop-down get it's values from the dataset, instead of hardcoding the list...
I'll be looking at other's submissions to see if there was a graceful way to do this.
I'll be looking at other's submissions to see if there was a graceful way to do this.
jamielaird
14 - Magnetar
05-07-2018
12:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my solution:
Spoiler
A little searching led me to the Collapse Group When Deselected trick, which I hadn't come across before, and will definitely be using again..
david_fetters
11 - Bolide
05-07-2018
12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
'Cheated' by using the output of a browse tool to populate the dropdown list, but until the dropdown can be populated dynamically, it takes the same steps as the other option of rerunning the app in alteryx if the style list should ever change.
ggruccio
ACE Emeritus
05-07-2018
05:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got crafty, and a little thirsty as well...oh well at least I have my water bottle right here!
Spoiler
Created an app using the detour tool.
Seemed as though the filter by "WY" in the example output was somehow showing multiple styles for each beer name. It had 66 rows. I pull 15 when I run the app.
Seemed as though the filter by "WY" in the example output was somehow showing multiple styles for each beer name. It had 66 rows. I pull 15 when I run the app.
GalynaSkamrova
7 - Meteor
05-08-2018
05:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution
05-08-2018
07:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ggruccio good catch! I updated the start file to reflect the correct results.
petgrap
8 - Asteroid
05-08-2018
12:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator