Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Data Matching / VlookUp in Alteryx

11 - Bolide

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?




11 - Bolide

Hi @SH_94,


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


I hope this helps. Best.

11 - Bolide

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