Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

List box and filter - where am I going wrong?

chickenlicken
8 - Asteroid

 

I'm trying to create a list box (which presents a list of options to the user from data contained within the workflow) which then changes the configuration of a filter.

 

I'm not sure what I'm doing wrong but I keep getting an error message when I run it. 

 

I also dislike my clunky text to columns approach to get the inputs for the list.  

 

Would be very grateful for your thoughts!

 

Farm snip.JPG

 

 

9 REPLIES 9
AbiramiJothi
7 - Meteor

Please check if the attached works.

Also, I didn't get any errors when running the workflow.

Can you add a screenshot of your error?

ddiesel
13 - Pulsar
13 - Pulsar

Hi @chickenlicken!

 

Try changing these configurations:

1) List Box (4) from "Select Tool Mode" to "Generate Custom List"

2) Action (5) change the Replace a specific string: to "Pignuts","Grass","Grain","Bread" (remove the outer parenthesis)

 

With those two small modifications, the app worked for me. Let me know if it works for you!

ZacharyM
Alteryx Alumni (Retired)

The error encountered is the result of running the workflow as an application, not just running the workflow (The magic wand button vs. the play button) - this is because the error is occuring when the update values occurs.

 

The solution as provided by ddiesel below solves the issue.

chickenlicken
8 - Asteroid

Many thanks all, this now works!  appreciated.

chickenlicken
8 - Asteroid

Actually one more question.  How do I use the output in a workflow?  I find when I connect the Filter to another tool, it uses the preselected Filter values rather than those that are chosen by the app.  Do I need to create a new workflow using the output from this app as the input?

 

Thanks again.

 

 

ddiesel
13 - Pulsar
13 - Pulsar

Hi @chickenlicken! Glad the settings worked for you!

 

The easiest way I've found to test apps is under View>Interface Designer>Test View. Make your feed stock selections and then click "Open Debug". Alteryx will open a new workflow with your selected inputs to test. Alternatively, you can just attach an output tool downstream from your filter, run the workflow as an analytic app (wand button), and check the output file.

 

I tested the workflow in Test View and with an Output and the selections work on my end. Let us know if it works for you.

 

SueDonim
8 - Asteroid

@ddieselthanks for your comments on this one.  I struggled with a List Box not updating for about 3 hours.  Your example ultimately pointed out my error - I had left a space between filter items I wanted to replace with List Box values.  Removing the space fixed it all

ddiesel
13 - Pulsar
13 - Pulsar

@SueDonim Thank you. I'm glad the example helped!

Animanga008
8 - Asteroid

Thanks for the solution!

Labels