Patient ID module

[AliKat]

Hi fellow healthcare Alteryx users! I was wondering if anyone else has been tackling the creation of a master patient index with Alteryx. I've built a module using fuzzy matching that considers name, birthday, ZIP, sex and SSN to try to match people across claims records. But I was curious what other people have done, if anyone else has tried this with Alteryx? Thanks!

[DavidV · Accepted solution]

Hi AliKat,

Have you skimmed thru the slides from Inspire17 from MedPro Group on Self-Service Fuzzy Match their innovation on the Fuzzy Match tool they call "Fuzzy Match Master"?  Look at the permutation of field order to improve match key score is Brillant! Get Geeky!

Slides: https://www.slideshare.net/Alteryx/medpro-selfservice-fuzzy-matching-inspire-2017

Video: https://www.youtube.com/watch?v=X3S7MSCmJjY

Gallery Macro: https://gallery.alteryx.com/#!app/Fuzzy-Match-Master/5936fb73effc2a0b7cc60818

Sincerely,

David

[AliKat]

This is a very cool macro! I watched the whole video and read all the slides. however, when I try to use the macro, literally nothing comes out. I get zero records coming out. I know there are matches in my data, because i get matches when I use just one fuzzy matching tool. Any suggestions about how to use the macro correctly...?