Hello,
I'm performing Fuzzy Match on 2 data sources, SAP and ORACLE. Some fields require exact match and some require custom match. I've set the settings accordingly in the attached example. I see there are matched records coming through. But I'm unable to display the output in a desired format. I'd like to have Matched and Unmatched records side by side. How can I achieve this?
Input:
Distributor | Reseller | Model # | Material Description | Total | Qty | Data Source | Year |
MENSTK | ELECTRONICS ARTS CO | ABC123 | HAND HELD DEVICE | 100 | 2 | ORACLE | 2017 |
MENSTK | INTELLIGENT AUTOMATION INC | ABC123 | HAND HELD DEVICE | 5000 | 123 | ORACLE | 2017 |
MENSTK | INTELLIGENT AUTOMATION | ABC123 | HAND HELD DEVICE | 5000 | 123 | SAP | 2017 |
MENSTK | ABC123 | HAND HELD DEVICE | 60000 | 1200 | SAP | 2017 |
Expected format: The column names need not be similar can be anything to distinguish between the data sources. Its ok if its the same too.
Data Source | Distributor | Reseller | Model # | Material Description | Total | Qty | Year | Data Source 2 | Distributor | Reseller | Model # | Material Description | Total | Qty | Year |
SAP | MENSTK | INTELLIGENT AUTOMATION | ABC123 | HAND HELD DEVICE | 5000 | 123 | 2017 | ORACLE | MENSTK | INTELLIGENT AUTOMATION INC | ABC123 | HAND HELD DEVICE | 5000 | 123 | 2017 |
SAP | MENSTK | ABC123 | HAND HELD DEVICE | 60000 | 1200 | 2017 | ORACLE | ||||||||
ORACLE | MENSTK | ELECTRONICS ARTS CO | ABC123 | HAND HELD DEVICE | 100 | 2 | 2017 |
From the Fuzzy Match output, you could use a Record ID tool to create a field [Match ID].
Join [Fuzzy Match Record ID 1] back to it's original data source
Join [Fuzzy Match Record ID 2] back to it's original data source
This will give you two data streams
Then use a JOIN tool to combine the two data streams using the Match ID
Chris
I tried to do the steps you mentioned as shown below. What am I missing?
Can you post that latest workflow, with just a few sample records?
Chris