Hi all: I've two datasets as below and I need to match those by Name. Sample datasets with dummy values along with desired output is given below. Idea is to match Names of dataset-A and dataset-B (pick all the exact matches plus values match very closely). I've tried to apply fuzzy tool but it's not providing me the accurate result. May be I've not configured the tool correctly. Need help guys. Dataset-A NAME-ABRENDAN PETERNATHAN BILLBRIAN LEEBRUCE AKINFREDDY LAMJASON JPETER FOLD Dataset-B NAME-BASSET NOBRENDAN PETER5551BRENDAN PETER SIM2121NATHAN BILL6677NATHAN BILL IPAD9911NATHAN BILL LAPTOP2111BRIAN LEE PHONE8811DIANA MILLER7999DIANA MILLER LAPTOP8080BRUCE AKIN2232BRUCE AKIN9988LAPTOP FREDDY LAM3343FREDDY LAM IPAD1121JASON J5421 Output NAME-ANAME-BASSET NOBRENDAN PETERBRENDAN PETER5551BRENDAN PETERBRENDAN PETER SIM2121NATHAN BILLNATHAN BILL6677NATHAN BILLNATHAN BILL IPAD9911NATHAN BILLNATHAN BILL LAPTOP2111BRIAN LEEBRIAN LEE PHONE8811BRUCE AKINBRUCE AKIN2232BRUCE AKINBRUCE AKIN9988FREDDY LAMLAPTOP FREDDY LAM3343FREDDY LAMFREDDY LAM IPAD1121JASON JJASON J5421 Thanks

Match strings exactly or pretty close to each other between two datasets

Hi all:

I've two datasets as below and I need to match those by Name. Sample datasets with dummy values along with desired output is given below. Idea is to match Names of dataset-A and dataset-B (pick all the exact matches plus values match very closely). I've tried to apply fuzzy tool but it's not providing me the accurate result. May be I've not configured the tool correctly. Need help guys.

Dataset-A

NAME-A

BRENDAN PETER

NATHAN BILL

BRIAN LEE

BRUCE AKIN

FREDDY LAM

JASON J

PETER FOLD

Dataset-B

NAME-B	ASSET NO
BRENDAN PETER	5551
BRENDAN PETER SIM	2121
NATHAN BILL	6677
NATHAN BILL IPAD	9911
NATHAN BILL LAPTOP	2111
BRIAN LEE PHONE	8811
DIANA MILLER	7999
DIANA MILLER LAPTOP	8080
BRUCE AKIN	2232
BRUCE AKIN	9988
LAPTOP FREDDY LAM	3343
FREDDY LAM IPAD	1121
JASON J	5421

Output

NAME-A	NAME-B	ASSET NO
BRENDAN PETER	BRENDAN PETER	5551
BRENDAN PETER	BRENDAN PETER SIM	2121
NATHAN BILL	NATHAN BILL	6677
NATHAN BILL	NATHAN BILL IPAD	9911
NATHAN BILL	NATHAN BILL LAPTOP	2111
BRIAN LEE	BRIAN LEE PHONE	8811
BRUCE AKIN	BRUCE AKIN	2232
BRUCE AKIN	BRUCE AKIN	9988
FREDDY LAM	LAPTOP FREDDY LAM	3343
FREDDY LAM	FREDDY LAM IPAD	1121
JASON J	JASON J	5421