LOOKUPs on SSIS

Hi,

I have sample data like below:


Name4 Name5 Name6
Name1 Name2 Name3
Name1 Name2 Name3 EFCL
Name1 Name2 Name3 EFVP

I want to replace by lookup the Name1 Name2 Name3 with X as well as Name1 Name2 Name3 EFCL,
Name1 Name2 Name3 EFVP with X.

What that mean is I use only the Name1 Name2 Name3 to determine the replace values,

How do I achieve this

thanks in advance
ken hanseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vikas GargBusiness Intelligence DeveloperCommented:
In SSIS Lookup you have to have the data source from where you are looking up the main data.

You can have a Lookup table having two column one having value like source and other has text X

So that you can match them using source data and retrieve the text column having values "x"
0
ken hanseAuthor Commented:
Any idea of using Fuzzy logic rather than hard coding use of LIKE??
0
Vikas GargBusiness Intelligence DeveloperCommented:
You can also use fuzzy lookup

This will help you to get the required result for your solution........
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ken hanseAuthor Commented:
I used Fuzzy Logic, I could not achieve the result, it says not match, How can I configure word matching in fuzzy lookup?
Eg.

Name1 Name2 Name3
Name1 Name2 Name3 EFCL

in the above two rows, I should give matched as output   irrespective of "EFCL".
0
Vikas GargBusiness Intelligence DeveloperCommented:
I think you need to set the similarity threshold value.

Because it depends on it the % of common values among the column
0
ken hanseAuthor Commented:
sorry for the late response, what is the % level we should put to achieve this?
0
Vikas GargBusiness Intelligence DeveloperCommented:
The % level depends upon matching text values and varies between 60 - 80 so try with some random values till you will achieve your goal
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ken hanseAuthor Commented:
good help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.