Hi - I wanted to create an analytic app that let user input multiple criteria for Filter tool.
Particularly, I do not want included Contracts that contain phrases: "DO NOT USE", "POTENTIAL", "2015 Progressive", "PROP CAT", "Unidentified Growth".
I know that in Custom filter this would look like this:
!Contains([Contract Name], "DO NOT USE")
AND
!Contains([Contract Name], "POTENTIAL")
AND
!Contains([Contract Name], "2015 Progressive")
AND
!Contains([Contract Name], "PROP CAT")
AND
!Contains([Contract Name], "Unidentified Growth")
I know that adding a List Box tool and letting user check/uncheck box for each contract is an option. However, this is very manual and considering that there are multiple thousands of contracts in the list seems tedious and impossible do go through the whole list.
Is there an option to just let user list criteria that will write custom filter and exclude contracts based on that criteria?
I know using a Text Box and Action tools will let user enter single criteria, but am having trouble setting this up for multiple criteria.
Please find attached input excel file as well as Alteryx analytic app.
