Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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