Data Matching / VlookUp in Alteryx

[SH_94]

Hi Community,

Currently i would like to some matching from Data A (Correct information ) to Data B (Incomplete/ incorrect information).

From the screenshot below, the data A is all the correct information (system generated) but the Data B is human typing ( the error due to human error or shortcut). May i know is it possible to do the matching in the alteryx ? Or it is impossible for alteryx to identify if they is big difference.

Basically ,i want to keep correct information  (Data A) and at the same time to obtain the total amount per person.

May i know if anyone of you know how to build the workflow in the alteryx?

[mot]

Hi @SH_94,

Fuzzy Match tool could tackle these types of use cases. You may find these resources helpful:

https://help.alteryx.com/current/designer/fuzzy-match-tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

I hope this helps. Best.

[randreag · Accepted solution]

hi @SH_94 

I attached an example of how the fuzzy match can work for you. Have to adjust the output

I hope it helps