Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

which formula can be used to get the this output

Happyparthipan
5 - Atom
2 REPLIES 2
davidskaife
14 - Magnetar

Hi @Happyparthipan 

 

A simple formula such as the below can be used:

 

DavidSkaife_0-1646943467882.png

 

Note: the 'ToString' function is to convert the number field to a string, as i have assumed the Phone Number field type will be numeric

 

Thanks

 

David

allwynthomas24
11 - Bolide

Hey @Happyparthipan,

Please check the attached workflow.

 

Thanks,

Allwyn

Spoiler
allwynthomas24_0-1646973190674.png

Input File Name - input.xlsx
Output File Name - output.xlsx
Labels
Top Solution Authors