Fuzzy Match with two sources

[Shan_Drex12]

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 Number	Product Description	Code
2G10689	B-1460-2   STAY	7326908588
2G2331	X106200-02 HANDLE	3926902500

Source 2:

Item Number	Product Description	Code
2G10689 / B-460-2 / TAKIGEN	stay - stopper of cover	7326908688
E106200-02 / 2G2331	Handle	7326908688

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)

4G4158	FILTER CARTRIDGE, REGLOPLAS	5911900080
3G10088	BEARING, 7201-BE2Z	8482105012

Source 2: LookUp Table 

Item Number	Description	Code
Filter Cartridge	Filter Cartridge	5911900080
Bearing	Bearing	8482105012

[grazitti_sapna]

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

Let me know if this helps.

Thanks.

[Shan_Drex12]

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]

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

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)

4G4158	FILTER CARTRIDGE, REGLOPLAS	5911900080
3G10088	BEARING, 7201-BE2Z	8482105012

Source 2: LookUp Table 

Item Number	Description	Code
Filter Cartridge	Filter Cartridge	5911900080
Bearing	Bearing	8482105012