Fuzzy matching

[sriniprad08]

Hi Team,

I have a situation where we need to find the "Same Description" but different "ID" and

a) create a match score

b) and an indicator with "yes" or "No" 

Please find below the dummy data,

Thanks

Sri

Id	description
409106869	01Isolierstoffgehäuse 3RV1913-1CA00
409107095	04-2000-20-700 Steuerventil, P4/P8, PP
409107095	04-2000-20-700 Steuerventil, P4/P8, PP
409107099	08-1010-51 Membrane Neoprene, A/P/T/W8
409107099	08-1010-51 Membrane Neoprene, A/P/T/W8
409107099	08-1010-51 Membrane Neoprene, A/P/T/W8
409107099	08-1010-51 Membrane Neoprene, A/P/T/W8
400930564	140GETASTER, TYP XAC-FAS 3251 TE GE, MIT
400930564	140GETASTER, TYP XAC-FAS 3251 TE GE, MIT
400930564	140GETASTER, TYP XAC-FAS 3251 TE GE, MIT
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931364	2/2-WEGEMAGNETVENTIL,
400931511	2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40,
400931511	2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40,
400931511	2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40,
400927713	2/2-WEGE-MAGNETVENTIL, TYP 5282

[sriniprad08]

Hi Team,

Any thoughts on this please?

thanks

Sr

[PhilippK]

Hello @sriniprad08 ,

Fuzzy Matching is a good fit for your challenge:

https://www.youtube.com/watch?v=ZPQA-k3rJgQ

https://help.alteryx.com/current/designer/fuzzy-match-tool

Quite advanced though, you need to spend some time on learning + fine-tuning Fuzzy Matching.

Best regards

Phil

[atcodedog05]

I guess this post is same as this one

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Fuzzy-matching/m-p/672517/highlight/fa...

Which has been solved😣