Skip to Content
0

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

Jan 12 at 02:08 PM

56

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Arun Sasi Jan 16 at 09:55 AM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks, Sasi!!

You shared link helpful for us.

0