SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

dfPower Studio 8.2 address scrubbing question

Reply
New Contributor
Posts: 2

dfPower Studio 8.2 address scrubbing question

We are on the dfPowerStudio 8.2 version, but will soon be upgrading to Data Management Studio.

When we input a 2-line address into the Address Verification (US/Canada) node, the result from the address verification node is concatenating the input address line 2 to the first line of the address.  We would like to be able to still have these lines separate after scrubbing.  Is there a way to continue to keep these 2 lines separate after being scrubbed?

Ex:  Input Address Line 1:  317 S Main St

       Input Address Line 2:  Apt 26

       Input City - State:  Milbank, SD

       Input Zip:  57252

Result from Address Verification Node:

       Address Line 1:  317 S Main St Apt 26

       Address Line 2:

       City:  Milbank

       State:  SD

       US_Zip:  57252


SAS Employee
Posts: 85

Re: dfPower Studio 8.2 address scrubbing question

ldpinkert,

Try using the Parsing node using the Address Definition for the Address Line 1 field. Output all available tokens then use an expression to concatenate the parsed tokens into Address Line 1 or Address Line 2:

/* Pre Expression */

string addr_1_update

string addr_2_update

addr_1_update = ''

addr_2_update = ''

/* Expression */

addr_1_update = `Street Number` & ' ' & `Pre-direction` & ' ' & `Street Name` & ' ' & `Street Type`  & ' ' & `Post-direction`

addr_2_update = `Address Extension` & ' ' & `Address Extension Number`

-shawn

New Contributor
Posts: 2

Re: dfPower Studio 8.2 address scrubbing question

Thank you.  That is helpful.

Ask a Question
Discussion stats
  • 2 replies
  • 276 views
  • 3 likes
  • 2 in conversation