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

[atcodedog05]

Hi @sriniprad08 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[sriniprad08]

hi @atcodedog05 

Thank you so much 🙂 . Does it test "Same description" but different "ID".?

Cheers,

Sri

[atcodedog05]

Hi @sriniprad08 

Yes thats right.

I used summarize because there were same ids repeated time multiple times. If you remove it it will compare one row with each other.

Hope this helps 🙂 

[sriniprad08]

Hi @atcodedog05 

Thank you 🙂 . Is it possible to add an column called "indicator " with values "yes " if the "description is same but the "id" is different and "No" other way.

Thanks for the help

Cheers,

Sri

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[sriniprad08]

Hi @atcodedog05 

Thank you so much :). I will check with my data and let you know .

But it looks perfect.

Happy thanks giving,

Cheers,

Sri

[atcodedog05]

Happy to help 🙂 @sriniprad08 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂