Fuzzy Match output Matched and Unmatched records

[monish_chandra]

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

[ChrisTX]

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

[monish_chandra]

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

[ChrisTX]

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

Chris