Create a variable and use it to filter

masiain

Hello, I have the following output:

ID	Content
1	/etc/passwd
1	root:!:0:0:Usuario De Sistema Operativo Super-User:/root:/usr/bin/ksh
2	/etc/hosts.equiv
2	el archivo no existe /etc/hosts.equiv
3	/etc/hosts.allow
3	el archivo no existe /etc/hosts.allow
4	/etc/hosts.deny
4	el archivo no existe /etc/hosts.deny
5	/etc/security/user

I am trying to do a search to find the "/etc/passwd" on Content column and then save the related ID into a variable, then use that variable into a filter tool and filter only the ID column with the variable.

The ID's are not always the same so harcoding the number into the filter does not work for the solution.

CharlieS

Hi @masiain 

I've attached a workflow that shows two methods to achieve the desired result: one using the Filter tool as requested, and another using a Join tool. Let me know if this works for you. 

20190619-ContainsFilter.yxmd