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!
