help with city and state seperation using QS

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
ashok
Participant
Posts: 43
Joined: Tue Jun 22, 2004 3:04 pm

help with city and state seperation using QS

Post by ashok »

Hi,
I am using standardize stage to seperate US city and state from one field, I am able to do correctly with first record and rest of records are comeing out with no change :oops: , applied USAREA rule,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is there white space between city and state in this field? Is state abbreviated or in full, or a mixture? Have you run any investigation over the data to determine which tokens are being identified as which under the USAREA rule? If so, what are the results of that investigation. You may need to design in some user overrides to bucketize city and state properly out of a single free-form field.
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