Alteryx Designer Desktop Discussions

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

1000 cell values concatenate to one cell only with delimiter ;

PassION_es
10 - Fireball

Hello Alteryx.

 

I have a thousand list of email address that I wanted to be concatenated or combined in to one cell only.

 

Here;

 

Input:  (all in one column)

aae@gmail.com

bahalaka@gmail.com

unsa@gmail.com

and so on and so forth........

 

Output:(with semi colon in between those email add) - output to one cell only

ae@gmail.com;bahalaka@gmail.com;unsa@gmail.com

 

Hope to help me with this.

 

Thank you in advance.

2 REPLIES 2
usmanbashir
11 - Bolide

@PassION_es - please see attached workflow. Hope this helps!

PassION_es
10 - Fireball

amazing @usmanbashir ,thank you so much!

Labels