Matching Data that is not exact

Question

Hello all! So I have a set of data that has a field named "Identifier" and it has records like: 1F004508122311111, Z10058841.1.5.1.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?

echuong1 · Answer

You'll want to remove the asterisk. The find and replaced is already doing a partial match looking for those keywords, so the wildcard is not necessary.

I went ahead and added identifiers for the match types and then created a consolidated list of them. Hope this helps!

Test Workflow.yxmd

laurennewton · Answer

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 Z7EASAAF1.2.1.1.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!

Test Workflow.yxmd

echuong1 · Answer

You can add a filter with the appended field not being null to remove the non-matches.