Help with Fuzzy Matching

James89

I have been trying to use Fuzzy Match to match for instance:-

1. Column Name: Sum_Net Pay with Value match against

2. Column Name: Wage Description with Net Pay along with Debit and Credit details.

Is there any method that I can do, or what would be the configuration in the Fuzzy Match setting

Datasets

Fuzzy Match

Accepted answers

Raj

@James89
find the workflow attached
mark done if solved.

3293.yxmd

All comments

Raj

@James89
please share sample workflow with sample data will be in better position to help

James89

Hi Raj,

Thanks for the reply Raj. I am not able to share the workflow as it confidential in nature. But the aim of the topic is as such:-

Name	Value	Wage Description	Dr Amount	Cr Amount
Sum_Net Pay	1	MEDICAL Ins	2	1
Sum_Overtime Allowance	3	Net Pay	2	1
Sum_Medical Insurance	1	Overtime Allow	3	0

How do I use Fuzzy Match tool to help me get Alteryx to find the closest match (with Name compared against Wage Description) to arrive at table below. Table below would be my plan intended outcome: -

Name	Value	Wage Description	Dr Amount	Cr Amount
Sum_Net Pay	1	Net Pay	2	1
Sum_Overtime Allowance	3	Overtime Allow	3	0
Sum_Medical Insurance	1	MEDICAL Ins	2	1

Thanks for providing the help!

Raj

@James89
find the workflow attached
mark done if solved.

3293.yxmd

James89

Hi Raj,

Thanks for the response. I have attached the workflow illustration to better describe the situation.

There are 3 files in the workflow attached and I would like to compare File B (Register 1) + File B (Register 2) against File A in terms of name and amount. However, the name used between File A and B might be different, but they carry the same meaning. For instance, File A used Sum_Basic, while File B used Basic Pay and the list goes on.

I have tried using the Find and Replace tools as suggested, though it helps, but Alteryx does not include the approximate similar wordings in the workflow for other items. Hence, I am thinking whether applying Fuzzy Match by just putting similar / approximate wordings with % accuracy would help in this case.

3293 (1).yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703