Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Oct 29, 2012 1:05 PM by user189718
Oct 24, 2012 11:06 AM
I am looking for some help desperately as I am struggling to find a solution to an issue.
I am extracting data from 4 or more sources. Each has got the customer name with their ID's. But most of the customers match up even though they spelt incorrectly.
For example row 1: Macys Ltd 123,
2: macys 456
3: Macys CO LTD 789
I was told to create a table in which it should merge all the records into one in the merge table.
macys ltd 123, MACYS 999
macys 456, MACYS 999
macys co ltd 789, MACYS 999
In that way 999 is common to all the records and it should generate only one ID for all the customers.
is it doable in OWB? I have tried in owb but it gives the same number of rows with the different id and its not merging into one.
Have I missed anything to work on owb itself?
Please help as I was suppose to finish this task couple of weeks ago.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: owb merge
Oct 29, 2012 1:05 PM
in response to
Is this task very difficult to achievable in OWB? If so are there any other ways to get this done. Please try to help me if you guys can.
Edited by: HarryOWB on 29-Oct-2012 06:04