COUNTY name

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
kogads
Premium Member
Premium Member
Posts: 74
Joined: Fri Jun 05, 2009 5:36 pm

COUNTY name

Post by kogads »

Hi All,
Is there a way to asign county name for the given address record in QualityStage?

Thanks in advance.
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Well .... The Country Rule set provides the two letters ISO country code, if it can be resolved from your data

Dowstream, after resolving the ISO country code you should do a look up against a lookup table with ISO country codes and the country names to get the country name
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
kogads
Premium Member
Premium Member
Posts: 74
Joined: Fri Jun 05, 2009 5:36 pm

Post by kogads »

JRodriguez wrote:Well .... The Country Rule set provides the two letters ISO country code, if it can be resolved from your data

Dowstream, after resolving the ISO country code you should do a look up against a lookup table with ISO country codes and the country names to get the country name
Thanks very much for your reply but I am looking for the COUNTY NAME(not the COUNTRY NAME[/b] for the given address.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There's nothing out of the box for county.

You could construct a lookup table perhaps based on postal code.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply