DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Fri Mar 16, 2012 3:00 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Does anyone have a creative way to match last names in instances when a person keeps their maiden name and appends their new last name?

For example, let's say MARY JONES gets married and changes her name to MARY SMITH JONES OR MARY SMITH-JONES. I need to match "SMITH JONES" or "SMITH-JONES" to her maiden name "JONES" which we have on file. Is there a way to match only the LAST characters in strings?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54431
Location: Sydney, Australia
Points: 295208

Post Posted: Fri Mar 16, 2012 3:20 pm Reply with quote    Back to top    

Are you using QualityStage? Are you able to use QualityStage?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Fri Mar 16, 2012 3:30 pm Reply with quote    Back to top    

[Ray,

Yes, I am. Sorry, I should have mentioned that. I know that I can use NAME_UNCERT if I was matching "SMITH JONES" to "SMITH" but how would I match "SMITH JONES" to "JONES"?

Thanks!

Glenn
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42834
Location: Denver, CO
Points: 220807

Post Posted: Fri Mar 16, 2012 4:38 pm Reply with quote    Back to top    

Off we go!

_________________
-craig

Your brain is full of spiders, you've got garlic in your soul, Mr. Grinch!
I wouldn't touch you With a thirty-nine-and-a-half foot pole!
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54431
Location: Sydney, Australia
Points: 295208

Post Posted: Fri Mar 16, 2012 6:58 pm Reply with quote    Back to top    

You could use REVERSE string, you could match the rightmost characters, you could generate Reverse Soundex.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Mon Sep 16, 2013 3:24 pm Reply with quote    Back to top    

Thanks Ray but...

- what is REVERSE string? Is that a DS function? I can't find that one.
- how do I match rightmost characters with QS? That's exactly what I want to do but don't see a way to do that.

Glenn
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours