Fuzzy Match - Merge Mode - 3 Data Sources
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MKlotz
6 - Meteoroid
‎07-21-2023
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am working with three different data sources and want to see where all three data sources are with 80% of each other. Is there an efficient way to merge fuzzy match to accomplish this?
Labels:
- Labels:
- Fuzzy Match
1 REPLY 1
Prometheus
12 - Quasar
‎07-21-2023
10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MKlotz Start with your Input Data configuration. Make sure "Output File Name as Field" is set to "File Name Only." Union your files so you have one column to fuzzy match on and one column with the file name. Drop a RecordID tool into each stream and make sure they don't overlap with each other so when you join the output of the Fuzzy Match tool back to your original data, you don't end up with multiple values identified by the same RecordID. Configure your Fuzzy Match tool with the FileName as your Source ID Field and RecordID as your Record ID Field.
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)