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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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 GargAssociate Principal EngineerCommented:
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"
ken hanseAuthor Commented:
Any idea of using Fuzzy logic rather than hard coding use of LIKE??
Vikas GargAssociate Principal EngineerCommented:
You can also use fuzzy lookup

This will help you to get the required result for your solution........
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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".
Vikas GargAssociate Principal EngineerCommented:
I think you need to set the similarity threshold value.

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

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
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.