Challenge #54: Data Prep Address Parsing

[ireneD]

Challenge solution by Irene Diomi

[Patrick_Silveira]

Solved

[MichaelPilotFreight]

Check out my solution!

[Kevin_VANCAPPEL]

Hello,

  here is my proposal.

  Regards,

  Kévin V.

[CandiceDB]

My solution:

Spoiler

[Kevin_VANCAPPEL]

Hello,

  here is my proposal.

  Regards,

  Kévin V.

[brandowd]

Hi @GeneR ,

I managed to get the answer using formula/regex (like others I didn't have access to any street lookups). I got zip / state very quickly but the 'City' proved a little more challenging given the number of words for the street / city. There's a bit of an assumption that 'roads' will definitely end in a certain name such as 'street' or 'circle'. For this case it's easy to fix but it doesn't make it a workflow that will work in all instances (or even in the UK) so I didn't really like what I'd done. Still fun though.

Spoiler

[DanTh]

Great to use the built-in Alteryx Address blocks!

Spoiler

I was hoping for a more dynamic solution, but it seems that replacing the "Street" types with delimiters was the easiest way to go. 

3/5

[Original_Yodies]

Spoiler

[TimN]

Spoiler

I need to learn Regex but was able to parse City with String Functions