Fuzzy Match output Matched and Unmatched records

Question

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:

DistributorResellerModel #Material DescriptionTotalQtyData SourceYearMENSTKELECTRONICS ARTS COABC123HAND HELD DEVICE1002ORACLE2017MENSTKINTELLIGENT AUTOMATION INCABC123HAND HELD DEVICE5000123ORACLE2017MENSTKINTELLIGENT AUTOMATIONABC123HAND HELD DEVICE5000123SAP2017MENSTK ABC123HAND HELD DEVICE600001200SAP2017

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 SourceDistributorResellerModel #Material DescriptionTotalQtyYearData Source 2DistributorResellerModel #Material DescriptionTotalQtyYearSAPMENSTKINTELLIGENT AUTOMATIONABC123HAND HELD DEVICE50001232017ORACLEMENSTKINTELLIGENT AUTOMATION INCABC123HAND HELD DEVICE50001232017SAPMENSTK ABC123HAND HELD DEVICE6000012002017ORACLE               ORACLEMENSTKELECTRONICS ARTS COABC123HAND HELD DEVICE10022017

Sample_Fuzzy_Match.yxmd

ChrisTX · Answer

Can you post that latest workflow, with just a few sample records?

Chris

monish_chandra · Answer

I tried to do the steps you mentioned as shown below. What am I missing?

ChrisTX · Answer

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