I am needing some assistance in creating a workflow that I can drop open item numbers as a filter and grab those open item numbers only against a master database. I am having trouble making this work, any ideas on a better way of keeping a workflow that can allow a filter to select open item numbers such as the attached workflow I am trying to build from?
@jennifer_aulet
If I understand correctly, we can use a Join tool
From J anchor, it would be the data having same Zip as the List of Zip code
Then R Anchor would be the data that NOT containing the Zip in the list of Zip code.
The workflow looks really good, from an improvement perspective you could consider turning this into an analytic app, allowing users to input the filters in via an app interface rather than through a spreadsheet. One consideration is depending on how you get users to input data will affect the way you push that downstream into your macro.
Thank you @Qiu this makes sense, how do I fix string fields can only be joined to other string fields? it looks to read right but not sure how to fix this to test if this can work.
@jennifer_aulet
You can use a Select Tool to change the data type.
@jennifer_aulet
In my case, I disabled the macro.