Matching Data that is not exact
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can add a filter with the appended field not being null to remove the non-matches.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
