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 was able to accomplish this in something I worked on recently by putting the filter in a macro with a control parameter and action tool that updated the filter formula. Then you build the filter formula using the data from your file 2 and feed it into the control parameter. Your other data can pass through the macro input/output.
Another way to do this is with a Find and Replace tool. You can set it to Append field on match, and then filter for cases where your appended field is not null. Then you can use a Select tool to remove the appended field.
Thanks Claje, this is close to what I'm looking for. is there a way to filter the different categories within field2 aka search terms? meaning after select the result of and and replace I want to be able to filter data, I , want, to , find into 5 separate output automatically. thanks.