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?
@wonka1234 you're seeing Louis next to that number because in the previous step you have conducted a join on the Cust_No, so the number for Louis finds itself. When you do the Find Replace you do actually get the number for Ren - if you tick to append the [Name] field as well you can see this:
This is correct based on the configuration you have - I assume you want this instead!
@alexnajm
@DataNath
Thanks. But how do I look for louis records only for louis'. I need to use Cust_nO somehow to only put my data from datsource 2 into data source 1.
What if I had this -
Name Cust_No NmmberLouis 55555 0000Ren 66666 6575Louis 5555 6575
@wonka1234 your explanation is a bit confusing - can you give us your updated workflow and expected output?
@alexnajm Sorry. I mean I want to do the lookup but Ren shouldnt be found in the final output.. Only if Cust # match then do the find and replace
@wonka1234 based on that explanation, it sounds like you want to do this. If this is not the goal, further explanation will be needed - it is best if we have the final expected output.
@alexnajm yes but then from here I need to compare Number columns... But i dont NEED exact matches, I need to see if Number2 is in Number or closely matched.
If that worked, then what is your expected output?
datsource 2 input -
6575
expected output -
perhaps even make this one row
@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.
@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.
No, because it is looking at Cust_No not Number.
