Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Fuzzy Match with two sources

Shan_Drex12
6 - Meteoroid

Hi All,

 

I am having some trouble fuzzy matching two sources together with similar item number OR description OR code. But, definitely not entirely the same. I just want to match as many items as possible.

 

Check out these columns below:

 

Source 1:

Item NumberProduct DescriptionCode
2G10689B-1460-2   STAY7326908588
2G2331X106200-02 HANDLE3926902500

 

Source 2:

 

Item NumberProduct DescriptionCode
2G10689 / B-460-2 / TAKIGENstay - stopper of cover7326908688
E106200-02 / 2G2331Handle7326908688

 

Thanks for the help! 🙂 

 

 

 

 

Source 1: Custom Codes (Match as much as possible in Source 2)

 

4G4158FILTER CARTRIDGE, REGLOPLAS5911900080
3G10088BEARING, 7201-BE2Z8482105012

 

Source 2: LookUp Table 

Item Number Description Code
Filter CartridgeFilter Cartridge

5911900080

BearingBearing8482105012
4 REPLIES 4
grazitti_sapna
17 - Castor

Hi @Shan_Drex12 , just for curiosity did you try find and replace tool? I have prepared a mock workflow.

 

grazitti_sapna_1-1603782117021.png

 

Let me know if this helps.

 

Thanks.

 

Sapna Gupta
Shan_Drex12
6 - Meteoroid

Thank you, this worked as well! However, how would I match the description or code after I matched all the possible item numbers?

grazitti_sapna
17 - Castor

@Shan_Drex12 , I believe it is clear that when we matched the item number it appends the field related to the sources as well but if you are specifically trying to match other two fields is it possible to provide a scenario why do we need that as in case for the 2nd record the code does not match therefore that record will not be included in the list if we keep code in the criteria. Also, can you tell me the priority of the fields that you want to use for fuzzy match. For instance, Item number- High, Description-medium and Code- low something like that.

 

 

Thanks. 

Sapna Gupta
Shan_Drex12
6 - Meteoroid

 

 

 

 

 

Source 1: Custom Codes (Match as much as possible in Source 2)

 

4G4158FILTER CARTRIDGE, REGLOPLAS5911900080
3G10088BEARING, 7201-BE2Z8482105012

 

Source 2: LookUp Table 

Item Number Description Code
Filter CartridgeFilter Cartridge

5911900080

BearingBearing8482105012
Labels