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
Solved! Go to Solution.
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.
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
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.
THANKS!!!!!!
The problem was I had
Start Text: "
Separator: ","
End Text: "
in stead of
Start Text:
Sparator: ,
End Text:
Thanks
:D
It works just when I select one item from the list box... It does not work if I select more than one :(
I am using the Alteryx 9.5 version
User | Count |
---|---|
34 | |
28 | |
7 | |
7 | |
7 |