Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi @Simon1187,
Attached is a workflow that matches your ideal output. However, I don't know if this will work for your actual data set as there were no phone numbers starting with 02 and you indicate you want to replace 03 or 02 with 61, which would leave your data without any numbers starting with 02. The Filter tool would only need to be for numbers starting with 61 instead of how it is written to filter for both starting with 61 or 02.
The way I approached this was thinking through the rules based on the data.
First, remove letters, punctuation and extra whitespace with the Data Cleanse tool
Formula rules (each rule looks at remaining records that did not meet the previous rule):
1. If the number starts with 61 or 69 then leave the number as is
2. If the number starts with a zero and the next digits after any zeros was 61, then remove leading zeros
3. If the number starts with a zero and the next digits after any zeros was 69, then remove leading zeros
4. If the number starts with a zero, remove zeros and add 61 to the front
5. All remaining records add 61 to the front
The only record that didn't match after applying these rules was record #16, which had a 3 at the end of your Ideal Phone Number, but didn't appear to have a rule to apply.
