topic Re: Filter column with Unique data in Alteryx Gallery Server Analytics App in Alteryx Server Discussions

Filter column with Unique data in Alteryx Gallery Server Analytics App

vibes360 — Mon, 04 Jul 2022 10:05:56 GMT

Hi,

I have built an Analytics app in Alteryx that I uploaded to Gallery. I have used a list box with an Action tool and the Filter tool to apply a filter to the data so that when a user runs the Workflow in Gallery, they can filter the data. However, when a user or I filter the data in Gallery, the filter doesn't work as the output of the workflow returns all the data. Please, I need your assistance configuring an analytics app to allow users to filter data in Alteryx.

I have attached screenshots of my workflow, filter logic, list box configuration, and action tool configuration.

Workflow

Filter Logic

Listbox configuration

Action Tool Configuration

Thank you for your help

Re: Filter column with Unique data in Alteryx Gallery Server Analytics App

BrianR — Tue, 05 Jul 2022 13:41:04 GMT

Hi @vibes360 , since I didn't have a copy of your actual app, I mocked up a quick example that should show a similar configuration that will produce the desired result. In this case, it will prompt (via a listbox) for any combination of four Regions and then produce the output. Take a look at the various tool configurations, namely, the List Box and the Action Tool. The List Box creates a custom List, and then inserts that list into the Filter via the Action tool.

Re: Filter column with Unique data in Alteryx Gallery Server Analytics App

vibes360 — Wed, 06 Jul 2022 13:15:54 GMT

Thank you very much @BrianR/. Your method works fine. I have a column in my data that has about 200 unique values. Please what logic would I use to allow the user filter data from the column or do I have to manually type in the 200 unique values in my Filter logic. For example, let's say I have 200 countries in my dataset and I want to filter country. Do I type in

[Country] in ('Brazil','Germany', .......)

in my filter tool for all the 200 countries or there is a better way to go about it?

Re: Filter column with Unique data in Alteryx Gallery Server Analytics App

BrianR — Thu, 07 Jul 2022 17:10:33 GMT

@vibes360 Yes, in this case, what would work better is a Join. By replacing the filter with a join, you can accomplish the same goal, the benefit is that you won't have to type in those multiple values into the filter. I modified the workflow to use a join instead, take a look.

Re: Filter column with Unique data in Alteryx Gallery Server Analytics App

vibes360 — Fri, 08 Jul 2022 13:40:14 GMT

Hi Brian,

Thanks for your reply. For the text input with column header 'Selections' that you connected to the text to columns tool, is that meant to have all the data in the column I want to filter in a single row format like you have typed it? The column I want to filter in my dataset has about 200 unique fields, do I have to type in the 200 unique fields in the same format you have done?

I'm not just sure how to create the data that goes to the left part of the join.

Thank you