Change filter from an APP

[macabrera]

Hi, 

I have a FILTER Tool with This Expresion -> [tipo] NOT IN ("[X]")

"[X]" is a connection comming from a list box. I want this to filter just the selected items in the List Box... But this is not working. 

Some one have an Idea how to do this?

Thanks

MC

[Aguisande]

Hi MC ,

You should try the Dynamic Input tool.

The basic workflow take data from "somewhere" (in your case "[X]") and modifies the query WHERE clause with the fields.

Define your template as the repository where you have the data to be selected, and then choos SQL: Update WHERE Clause:

Hope this heps.

[macabrera]

ok... The problem is I am building an APP, and I have to filter the file with the information that the user Select in the APP.

Like this

1. Select from a List Box 

2. The Expression in the FILTER tool must be modified

3. I should work only with the data of the Users selected items in the List Box

[Aguisande · Accepted solution]

Ohh, now I get it (mostly I believe I did).

This is how your FILTER TOOL should be:

This is how your LISTBOX should be:

Hope I got it right and this helps. If not, add your workflow to the post so I can take a look at it.

[macabrera]

THANKS!!!!!!

[macabrera]

The problem was I had 

Start Text:  "

Separator:  ","

End Text:   "

in stead of

Start Text:

Sparator:    ,

End Text: 

Thanks

:D

[macabrera]

It works just when I select one item from the list box... It does not work if I select more than one :(

[Aguisande]

It shouldn't. Can you attach your workflow?

I'm attaching a very basic one, that works with multiple selections.

[macabrera]

I send my APP.. Just I can't send the data files :(

[macabrera]

I am using the Alteryx 9.5 version