community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Consecutive Row Fuzzy Match

Atom

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

Alteryx
Alteryx

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

Atom

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.

Alteryx
Alteryx

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