dbTalk Databases Forums  

Partial Fuzzy Lookup?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Partial Fuzzy Lookup? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM






I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #12  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM






I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #13  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM



I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #14  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM



I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #15  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM



I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #16  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM



I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
  #17  
Old   
dtbascent
 
Posts: n/a

Default RE: Partial Fuzzy Lookup? - 06-04-2008 , 03:54 PM



I discovered that the basic functionality I need is supported in the fuzzy
lookup task. You can specify requiring an exact match on some columns, and,
at the same time, a fuzzy match on others. To handle the "Like", I
essentially did create a view that did the like matching first and tied the
matching key identifiers in both tables. Then in the fuzzy look up I exact
matched on the keys and fuzzy matched on the remaining columns.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.