Alteryx Designer Desktop Discussions

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

How to add 2 email ids in formula tool

sathyaKPMG
7 - Meteor

I have created the new columns as email under formula tool by using that field I need to abc@gmail.com and def@gmail.com  how  to add these two fields 

 

3 REPLIES 3
ShankerV
17 - Castor

Hi @sathyaKPMG 

 

Could you please share an example as could not get more details on the below question.

 

Thanks in advance.

sathyaKPMG
7 - Meteor

i have email field created under that i have 2 email ids i am using those email ids in email tool as a string .So inititaly i have added one email id as abc@gmail.com so its mapped under email field as it is , but how to add 2 values . i have tried abc@gmail.com + def@gmail.com since it is wrong .Can you help how to add those

ShankerV
17 - Castor

Hi @sathyaKPMG 

 

When you want to use 2 email id's in EMAIL tool, then you need separator as ;

 

In the Email ID column add in the below format.

 

"abc@gmail.com+ ";" + "def@gmail.com"

 

Many thanks

Shanker V

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels