Forum Discussion

kb177's avatar
kb177
Icon for Helper II rankHelper II
3 years ago
Solved

Merge query fuzzy match

Hello,   I have two table from different source and I'm using Fuzzy match for merge   but for few names fuzzy match is not working if I'm not giving Threshold limit   eg. S.John  in table 1  an...
Need Help
Show and Tell
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi kb177 

    You can try a couple of things.  If you have known transformations like S.John -> Saint John then in one table, replace the value with the one you want it to match.  So (for example) replace S.John with Saint John.

    Or you can use a Transformation Table in the fuzzy match which explicitly tells PQ what words/phrases to change/match

    regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi kb177 

You can try a couple of things.  If you have known transformations like S.John -> Saint John then in one table, replace the value with the one you want it to match.  So (for example) replace S.John with Saint John.

Or you can use a Transformation Table in the fuzzy match which explicitly tells PQ what words/phrases to change/match

regards

Phil