Fuzzy Match with two sources

Question

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 DescriptionCode2G10689B-1460-2   STAY73269085882G2331X106200-02 HANDLE3926902500

Source 2:

Item NumberProduct DescriptionCode2G10689 / B-460-2 / TAKIGENstay - stopper of cover7326908688E106200-02 / 2G2331Handle7326908688

Thanks for the help! 🙂

Also, some of the items I would like to match doesn't have item numbers but similar description.

Also, for the priority (Item number- High, Description-medium and Code- low) that would be the order.

Check out this sample below:

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

4G4158FILTER CARTRIDGE, REGLOPLAS59119000803G10088BEARING, 7201-BE2Z8482105012

Source 2: LookUp Table

Item Number Description CodeFilter CartridgeFilter Cartridge5911900080

BearingBearing8482105012

Shan_Drex12 · Answer

Totally fair, some of the items I would like to match doesn't have item numbers but similar description.

Also, for the priority (Item number- High, Description-medium and Code- low) that would be the order.

Check out this sample below:

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

4G4158FILTER CARTRIDGE, REGLOPLAS59119000803G10088BEARING, 7201-BE2Z8482105012

Source 2: LookUp Table

Item Number Description CodeFilter CartridgeFilter Cartridge5911900080

BearingBearing8482105012

grazitti_sapna · Answer

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

Shan_Drex12 · Answer

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