Populate ListBox based on Dropdown List selection

Greetings All!

I am trying to create an alteryx app that would accept user selections and output a set of records based on the filtered criteria generated based on the user selections. For this, I am trying to populate a checkbox list based on the values selected from a dropdown list. I am able to get the name-value pair until before the checkbox list, but the Checkbox list for some reason is not accepting the values. I am attaching my workflow for your reference. Could you please guide me to achieve my objective? Thank you in advance!

myWorkflow.yxwz

Developer Tools

Apps

Accepted answers

Kenda

Hey @geeman! Have you heard about chained apps? This might be helpful in this situation. The options for your second question depend on how the user answers the first question. To do this, you would separate your one workflow into two. The first would end when you write to your test file. The second would start with the input as the test file and use that to populate the list box. In order to have the second run after the first, in your first workflow, go to the Interface Designer and click on the wrench. You will then want to select 'On Success - Run Another Analytic App' and choose your second workflow. Also, you don't want this test output to be shown to the user so you can deselect the 'On Success - Show Results to User' for just this first workflow.

Here is an article that gives more details on chained apps: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7597

Chained App.PNG

MarqueeCrew

@geeman,

My concept was one of a tree:

If you know the group/subsets that can exist, then you can create and organize the data so that you can have a static set of data ready for all future workflows. For one of my client's each time I add new data to their database, I update the structure (tree) so that as new files are received, they appear on future application screens for selection. Otherwise, as @Kenda suggests, you could run a set of chained applications together and once you know that you're looking at a particular subset of data, you can pass that to the next workflow. When passing to the next application, my concern is what happens if 2 or 3 executions of the same applications are run simultaneously? You might need to engineer that one a little more carefully for scalability.

Attached are some quick and crude workflows to build and to execute the tree.

Cheers,

Mark

listbox 01.yxwz

listbox 00.yxmd

All comments

MarqueeCrew

@geeman,

Take a look at this macro for some help...

Cheers,

Mark

Filter Match.yxmc

Kenda

Here is an article that gives more details on chained apps: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7597

Chained App.PNG

geeman

Hi @MarqueeCrew MarqueeCrew,

Thank you for the quick response! I will take a look at this option and update you. Thanks again, Cheers!

geeman

Thank you @Kenda, for the quick response! This is seems to be a good solution, but I have multiple similar scenarios with in the workflow and I am looking for a solution that can be contained with in one single App. But I will definitely give it a go if nothing works. Thanks much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703