Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Data Matching / VlookUp in Alteryx

SH_94
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?

Jacob_94_1-1615014480525.png

 

 

2 REPLIES 2
mot
11 - Bolide

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
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

Labels