Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

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.

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