BusinessObjects Board

Finding Town in DQ

dataservices data quality
#1

Hi All,

I have one scenario where i have to find town with the help of other components.(am not getting TOWN from Input)

I am using French Address Cleanse transform. Can you please help AS I am not able to find the town?

I/P:

  1. STREET(sometimes contain HOUSE NO also)
  2. House No(If street doesnt contain House No, then it will be present in this fiield)
  3. CITY
    4)postal code

What i Mapped:
LOCALITY1 --> CITY
MULTILINE1 --> STREET
MULTILINE2 --> HOUSE NUMBER
POSTCODE --> POSTCODE

Example:

  1. GEBROEDERS DE WINTERSTRAAT {Street}
  2. 64 {House No}
  3. LILLE {CITY}
  4. 2275{POSTCODE}

Problem: When i take LOCALITY1_BEST_COMPONENT in “Output” fields i am getting the result as “LILLE” which is a CITY/Muncipal.

Here, They have 4(a,b,c,d) Towns under “VILLE” CITY.
Where the street “GEBROEDERS DE WINTERSTRAAT” belongs to the town “C” under CITY “LILLE”.

SO, i need TOWN name “C” in the output as well as CITY as “LILLE”.

Hope am clear!.

Thanks & Regards,
Amarnath.

amarchegu (BOB member since 2014-05-22)