Consecutive Row Fuzzy Match

Question

Hola to all the members,

Just had a question on fuzzy match. 
Data Sample

ID  Name

1  ABC

2  Abcd

3 Abghs

4 Abghd

5 Fas

I want to perform fuzzy match in such a way that it compares consecutive rows i.e. 1&2, 2&3, and so on and not all the possible pairs(1&3, etc.)

Is there any way to do that?

Hoping for the answer to my first question. Let the ideas flow.

Regards,
Ropra

wdavis · Answer

Hi @ropra

How many rows of data are you bringing in to your fuzzy match tool?

Are you happy that the logic for your fuzzy match is working correctly when it does run?

Will

ropra · Answer

Hi @wdavis
As soon I posted this question, I am using this myself but the problem is the amount of data which makes the workflow too slow.

Thanks for such a fast reply. 😛

wdavis · Answer

HI @ropra

One potential option would be to use the Fuzzy Match to compare all records, then add in a formula tool after this to create a flag for pairs that you want to check - "IF [RecordID2]=[RecordID]+1 THEN 1 Else 0 ENDIF" You could then filter out the results to only look at records that match the criteria.

Regards

Will