ksalem
6 years agoNew Contributor III
Filter expression evaluate against all input documents
Hi All,
I am currently working on an integration which requires a subset of the documents I currently have.
e.g.
ID | Name| Position | SecID
1 |Bob | Architect |4
2 |Joe | Architect |3
3 |Steve | Secretery |
4 |Martin| Assistant |
5 |Eric | BA |
6 |Tom | PM | 5
This subset in this example would be the the list of all records with the position architect and also there secretaries
E.g.
ID | Name| Position | SecID
1 |Bob | Architect |4
2 |Joe | Architect |3
3 |Steve | Secretery |
4 |Martin| Assistant |
I am aware I can do this in a script snap but wondering how if at all this could be done in the filter snap in a single expression?