Address standardization challenge (Malaysia Address)

Good day,

I'm new to Alteryx, trying to do address standardization but not sure how to do fuzzy match using another input file as reference source to find missing / invalid postcode (missing a digit) and get the value from reference file to replace missing/invalid value in the address.

The requirement (see attached workflow):

Req 1: To reference the Postcode Reference File to find missing postcode, or state name in the address and populate "Output" column.

The expected outcome is in "Required Output" text input.

In the workflow, I manage to do for postcode which are fully match but not partial match. Any idea how I can enhance the matching to also cater for partial postcode found? I tried using "City" as additional criteria to search for valid postcode to match but not sure how to do it in the formula tool.

Need some help, please advise, thank you!!

Address.yxmd

Regex

Fuzzy Match

Accepted answers

DanielG

@karenlmk - what about something like this. Doesnt use fuzzy match, as I have not perfected their use yet but it should get you what you need.

Address.yxmd

All comments

karenlmk

What I really want to do is to be able to use the reference file and loop through the addresses to find whether there's a "postcode + city" match, or match a fully formed postcode. If match, populate the output to a standard format. Thank you!

DanielG

@karenlmk - what about something like this. Doesnt use fuzzy match, as I have not perfected their use yet but it should get you what you need.

Address.yxmd

karenlmk

@DanielG Thank you so much for sharing the solution! Didn't thought of using Find and Replace tool before. It came in handy! I'll see how to use it to enhance further of the workflow. Again, appreciate the help!

DanielG

@karenlmk - no problem.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167