In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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