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

[chandrasekhar6]

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

[former_member198401 · Accepted solution]

I hope you are following the correct flow

https://blogs.sap.com/2012/07/17/sap-business-objects-data-quality-usa-address-cleanse-transform/

Regards

Arun Sasi

[chandrasekhar6 · Accepted solution]

Thanks, Sasi!!

You shared link helpful for us.