Phone Number conversion to international standards like E.164 in Experian Aperture Data Studio
Budget: ₹600 – ₹1,500 INR
Convert all phone nos to E.164 Format in Experian Aperture Data Studio .
Project Description:
I need a workflow using a reusable function inside Experian Aperture Data Studio that converts every mobile number in one of my tables to the E.164 standard. The source column phone nos has —just digits, no spaces or punctuation—but it contains numbers from Australia, New Zealand and several European countries, so the logic must detect the country context and append the correct international code (e.g. +91, +61, +64 , +44, etc ) after validating length and structure. Ex : 0412345678 should be converted to +61412345678 ( this is the case for an Australia no)
The original value must stay intact; the routine should add a second column (or write to a staging table) with the newly internationalized version so I can audit results at any time. There are 3 columns having similar phone nos. So the same logic shall be applied to all the columns storing phone nos.
Please build the solution entirely within Aperture, making use of its AI-driven data-quality functions, Phone Validate component, custom expressions or regex as needed. I want to be able to drop the step straight into an existing workflow—no external calls or additional software.
Project Description:
I need a workflow using a reusable function inside Experian Aperture Data Studio that converts every mobile number in one of my tables to the E.164 standard. The source column phone nos has —just digits, no spaces or punctuation—but it contains numbers from Australia, New Zealand and several European countries, so the logic must detect the country context and append the correct international code (e.g. +91, +61, +64 , +44, etc ) after validating length and structure. Ex : 0412345678 should be converted to +61412345678 ( this is the case for an Australia no)
The original value must stay intact; the routine should add a second column (or write to a staging table) with the newly internationalized version so I can audit results at any time. There are 3 columns having similar phone nos. So the same logic shall be applied to all the columns storing phone nos.
Please build the solution entirely within Aperture, making use of its AI-driven data-quality functions, Phone Validate component, custom expressions or regex as needed. I want to be able to drop the step straight into an existing workflow—no external calls or additional software.