List box and filter - where am I going wrong?

[chickenlicken]

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!

[AbiramiJothi]

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 · Accepted solution]

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]

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]

Many thanks all, this now works!  appreciated.

[chickenlicken]

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]

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]

@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]

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

[Animanga008]

Thanks for the solution!