List box and filter - where am I going wrong?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Apps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks all, this now works! appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SueDonim Thank you. I'm glad the example helped!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the solution!
