September 28, 2010 at 3:28 am
Hi all,
I am new to SSIS Please bare with me.
Here is my scenario.
I have two tables TableA and referetable TableB
create table tablea ( country varchar(100),city varchar(100),clean_city varchar (100))
Create table tableb( city_country varchar(100),input_city varchar(100), output_city varhcar(100))
I want to implement this in SSIS
LOOKUP FOR CITY IN INPUT_CITY WHERE COUNTRY = CITY_COUNTRY.
How can I acheive this using fuzzy lookup.
Any help is really appreciated.
September 28, 2010 at 3:47 am
Deepthy (9/28/2010)
Hi all,I am new to SSIS Please bare with me.
Here is my scenario.
I have two tables TableA and referetable TableB
create table tablea ( country varchar(100),city varchar(100),clean_city varchar (100))
Create table tableb( city_country varchar(100),input_city varchar(100), output_city varhcar(100))
I want to implement this in SSIS
LOOKUP FOR CITY IN INPUT_CITY WHERE COUNTRY = CITY_COUNTRY.
How can I acheive this using fuzzy lookup.
Any help is really appreciated.
Firstly, I think you meant 'bear', unless you have some communal flashing aspirations 😉
Secondly, can you describe why you need to use a fuzzy lookup here? What's wrong with a normal lookup, or a join? A sample of your data would be illuminating.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 28, 2010 at 3:52 am
Sorry bear with me:-).
I got to clean my city data in TableA based on the similarities and confidences, want to use fuzzy match so that can clean any cities with spelling mistakes, special characters and numbers using the reference table input_city.
My city column is with data like
'Lonon'
'MANCHASTAR35'
'6765 Derby'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply