Address standardization challenge (Malaysia Address)

[karenlmk]

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!!

[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 · Accepted solution]

@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.

[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.