This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am building an alteryx app to look at sales in a specific store group. My plan was to use a listbox to allow the user to select which group of stores that they would like to analyze. This listbox would then update a filter that is connected to a join. This join filters out the specified stores from the original dataset. However, so far this method only returns a workbook with 1 store in the list. I have attached a picture of my input for the listbox, my filter, and my workflow. Any advice?
@lharris17 I would use the interface designer >>> Test View to try out my app. You can use the Open Debug then to see what is being populated in the filter tool. Hopefully this can help you figure out what's wrong. If I had to guess what's wrong, be sure your list box is generating a custom list with a comma as the separator:
The action tool can cause trouble, but the fact that it's returning 1 store in the list means it's less likely a problem with the action tool.
@lharris17 Thanks for posting the workflow, that makes it a lot easier to debug! Here is what I did:
I ran the debugger:
I then looked at the filter to see that it's not configured as expected. Also note that the comment added shows you the list box is trying to pass "Type A, Type B, Type C":
Back in your original flow, you have your action tool selecting the custom line instead of your formula 1 line above it:
But from the debugger I see that it's passing Type A, Type B, Type C (instead of the store numbers). So i tweaked your flow to transpose the store list, apply a filter to it, and then join that back to your sales data.
One more question. My organization has not updated to the new version of Alteryx and I have issues opening workflows created in the new version. I have never uploaded anything to the gallery, but do you think that would allow me to view these workflows?