Find and replace Value is not accurate

[wonka1234]

Hi,

I am trying to use find and replace to bring in matched or semi matched strings.

but in my number2 column - this doesnt belong to Louis. It belongs to Ren.

How can I fix this?

[alexnajm]

@wonka1234 having that extra row in your datasource 2 will cause the Join to duplicate since you have Louis twice, and it also is not ideal for a Find and Replace since it will only find one match. but technically it gets you closer to the expected output.

However, I think we are still unclear on what is being done so clarifying that will help.

[wonka1234]

@alexnajm  IF i did the photo above, technically I could get a match with Ren as she has the same "6575" number as Louis right? So I need a way to Look for Cust Number EXACT match between 2 data sources. and a "Fuzzy Match" between "numbers" column. 

[alexnajm]

No, because it is looking at Cust_No not Number.