This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am having some trouble with the filtering in my workflow. My goal is to filter the data from an input as below:
Essentially, the incoming data from the first source is fist filtered into those that were reviewed and those that were not reviewed (null). If they were not reviewed and they are NOT inactive (also null), then these users would be exported to a Unreviewed users doc.
On the other hand, those that were reviewed are filtered to those that have any modifications (aka anything other than null or some version of "ok"). These users are exported to a User modifications file.
Additionally, the filtered users that have modifications are then checked against an updated access file with a join, which should not include the specific name+group combo that was requested to be removed. If they are still in the updated listing, those users are exported to a User exceptions file.
I made dummy data that would fall into each of these scenarios and found that none of the filters are working in the way I intended. This is my first workflow, so easy to understand responses are appreciated. Thanks!
Thanks for the files. I have made a few edits to the second filter and used the formula contains([Business Feedback],"Ok"). It looks like it is working fine now. For the 3rd filter, you didn't have any possible matches so I added a text input to test it and it looks like it is working fine. Please let me know if this helps.
So it works great on the dummy data, but I just realized when I make the same filter changes to my actual file that the filters are not applying. Instead all users that do have "ok" and null in the feedback column are being returned. I'm not sure what could be causing this. I cannot share the entire data file, but this is what that section appears as in Alteryx as the data source and then the User Modifications output: