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.
Hello all! So I have a set of data that has a field named "Identifier" and it has records like: 1F004508122311111, Z10058818.104.22.168.2. I need to match another set of data that has the field name "Reference" with records like: Z6TZCAAN, Z6TBDAAX11101*. The goal is to find any EXACT matches (if there are any) of records like Z6TZCAAN from Reference to any exact matches in Identifier. Then to also find wild card matches of records like Z6TBDAAX11101* from Reference to any possible matches in Identifier. Any ideas how to incorporate both of these kinds of matches?
You can use a join to identify exact matches - these would come out of the J output. Any non-matches would come out of the L or R output (depending on which one you had your reference table attached to). You can then use a find and replace (with the append feature) to identify your wildcard matches.
I've attached my sample workflow below. When I add the filter tool its not giving my desired output. There are three example data records that are possible wildcard matches, in the desired output I should see only Z6TMCAY30112AA048999.2 and Z7EASAAF22.214.171.124.6.1.29988 as wildcard matches. With the find and replace I have all three records coming through, when I add the filter at the end it doesn't give me my desired output.
I'm sure I'm making a small mistake in my workflow so I appreciate all the help!