Split a value into multiple rows

Luke

Hi

I have full addresses split by ; that I want to split out into new rows ready for the Address Validate step.

An example of the data layout ...

"Address1 Address2 Address3 Town County Postcode;Address1 Address2 Address3 Town County Postcode"

This should become two rows

"Address1 Address2 Address3 Town County Postcode"

"Address1 Address2 Address3 Town County Postcode"

Does anyone know if this is achievable in Aperture?

Thanks

Luke

Josh Boxer

Hi Luke

Roughly how many addresses are there in that semi-colon separated list?

Two ideas:

1. Upload the data using semi-colon as the delimiter so that each address becomes a new column then in a Workflow use Columns to rows and select every column turning them into rows
2. create a custom file parser https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-sdk/#getstartedwiththesdk

Hoping someone will reply with a better suggestion!