Sign in · Register

Split data from two columns - phones

CarolynCarolyn Contributor
in General discussion

hi

I have a situation when l have a file that has two columns with phone data:

Phone Phone2

99998888 0411888999

0408999888

88887777

0401777666


I want to take any mobile number in either column and move to a new column called Mobile Phone and the other Phone so end result is

Mobile Phone Home Phone

0411888999 99998888

0408999888

88887777

0401777666

Any assistance appreciated.

thanks

Answers

  • Clinton JonesClinton Jones Experian Elite

    This will likely only work for Australia and New Zealand but what I would do is determine the phone number type first, using the phone validation step.

    you'll need to surface two new columns in your data accordingly from dual pass of the phone validation step

    image.png

    Note that I chose Vaid Phone as the Validation Type

    The slot number transform hides the superfluous columns and adds a new column called Mobile Number

    image.png

    You start with just the two columns

    image.png


    and after this first step and action you get this

    image.png


    the challenge is going to be if both phone1 and phone2 have mobile numbers, then what do you do?

Sign In or Register to comment.