Skip to Content

How separate Region, City, Country and Postal code using Address field in Data Services?

Hi

How to Spilt data by Region, City, Country and Postal code using Address field.

I have tried process as below,

Transformation Name:USARegulatoryNonCertified_AddressCleanse

In USARegulatoryNonCertified_AddressCleanse transform, I have mapped input Address field only.

and select output fields Region, State, Country and Postal code.

Ex:

1750, East 4th Street
Santa Ana, CA 92705 US

In above address how to divide separate columns like

Building No:1750

Street: East 4th Street

City: Santa Ana

Region: CA

Postal Code: 92705

Country: US

Please help me on above scenario.

Thanks,

Chandrasekhar .K

ad.png (6.9 kB)
error.png (43.8 kB)
address.png (11.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 16 at 09:55 AM
    Add comment
    10|10000 characters needed characters exceeded