Hi, I have two files to match between. In one file I have a column which contains a description of a product and the same structure in the other. I want to test how many words match between the two, for example: Description 1Description 2words matchSENSOR DISP.F.OXYMETER NELLCOR904-NSENSOR DISP.F.OXYMETER21320011 - HEPA FILTER 1320011- HEPA FILTER ESC120013CATH. ENDOTR. BLUE LINE CUFFED טובוס 8CATH. ENDOTR. 2 Thanks, Amos

Thanks for the effort, I'm not sure why, but I'm having trouble downloading the macro. However I used your first solution with a combination of Fuzzy match from 1% match and that pretty much solved it so thank you very much, it was very helpfull. Thanks, Amos

Hi @Amos1980, If I am understanding you correctly, you need to compare every row from one file to every row in the other file. While this could be done using an Append Fields tool, I am thinking a batch macro may work better. This batch macro compares every row from Description 2 and compares it to each row in Description 1. The workflow then summarizes the word count and puts the two descriptions side by side. Batch Macro Workflow v2 Word match between two fields.yxzp

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Word match between two fields

Amos1980

Hi,

I have two files to match between. In one file I have a column which contains a description of a product and the same structure in the other. I want to test how many words match between the two, for example:

Description 1	Description 2	words match
SENSOR DISP.F.OXYMETER NELLCOR904-N	SENSOR DISP.F.OXYMETER	2
1320011 - HEPA FILTER	1320011- HEPA FILTER ESC12001	3
CATH. ENDOTR. BLUE LINE CUFFED טובוס 8	CATH. ENDOTR.	2

Thanks,

Amos

Accepted answers

All comments

T_Willins

Hi @Amos1980,

It takes some data cleansing and may not exactly match your needs, but this workflow gives the result you wanted. You may need to tweak the data cleanse based on your actual data, but this should give you a start.

word match between two fields.jpg

Word match between two fields.yxmd

Qiu

@Amos1980
Basically same with @T_Willins approach, and I am thinking a library of delimeter might be easy to use.
So if there is some thing new, just update the red line part.

1021-Amos1980.yxmd

Amos1980

Thanks,

The thing is that I couldn't use the record ID since the two fields I'm comparing are in different files and are located in different rows.

What can I do then?

Thanks,

Amos

taylorbyers

Is there a way to use this to output a list of words that were matches?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703