Start Free Trial

Alteryx Designer Desktop Discussions

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

the filters in my alnalytic application don't work

TFrankD237
7 - Meteor

Hello
i'm new to the alteryx and i'm having a problem

I'm making an analytical application but I notice that when I run it the filters don't really work the low configuration works but when I make other filters I get nothing in the output file.

here is the basic configuration in the workflow  

config de base .png

as soon as I modify the (filter example in the following screenshot) it doesn't work I get an empty file as output and this configuration should output a file with information.

test.png

here is the WF attached
thanks for your help

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@TFrankD237 
Can you also share the Data file "Game.csv"?

TFrankD237
7 - Meteor

this is datafile

SPetrie
13 - Pulsar

 

For platform, your replace specific string had a space before PS4 but the formula didnt, so no matter what you chose it was keeping PS4 as the platform which caused the filter to return blank for non-PS4 selections.

 

Your filter for Year was setup as [Year] in ("2015"), but you only allow for one selection so [Year] = "2015" would be more appropriate there.

 

Genre was setup as [Genre] ="Action", but it allows for multiple selections, so in would be better there. [Genre] in ("Action") and have the action tool replace "Action" including the quotes.

Your list was also setup in select tool mode, which will generate Action=True,Adventure=False etc. as the output. You want that to be setup as Generate Custom List instead.

list.PNG

I attached the workflow with the updates. Hope this helps

 

Labels
Top Solution Authors