topic Re: Aligning dynamic email address in Alteryx Designer Desktop Discussions

Aligning dynamic email address

Kallis — Mon, 21 Jul 2025 10:46:12 GMT

Hello friends

I want to align the incoming dynamic email address as given in the output.

Incoming

abc@yahoo.com

ponting@gmail.com

dravid@gmail.com

bumrah@outlook.com

siraj@outlook.com

unique@yahoo.com

Expected Output

abc@yahoo.com ; ponting@gmail.com ; dravid@gmail.com ; bumrah@outlook.com ; siraj@outlook.com ; unique@yahoo.com

Kindly let me know how this can be achieved.

Re: Aligning dynamic email address

abacon — Mon, 21 Jul 2025 15:11:09 GMT

@Kallis You can use a cross tab to easily achieve this. You will concatenate them using the semi-colon as the separator.

Bacon

Re: Aligning dynamic email address

Pilsner — Mon, 21 Jul 2025 15:19:48 GMT

Hello @Kallis

If you are trying to combine multiple rows from a single column into a single cell, I typically use the summarise tool.

In here, you can select the action as concatenate and then specify your separators at the bottom. I believe this will achieve the result you're after.

Having said that, I do like @abacon's solution too, I always forget the crosstab tool can be used in situations like this!

Hope this helps.

Regards - Pilsner

Re: Aligning dynamic email address

Kallis — Tue, 22 Jul 2025 08:44:56 GMT

Hi @abacon @Pilsner

Thanks for your solution. Both of them worked perfectly.

Re: Aligning dynamic email address

Pilsner — Tue, 22 Jul 2025 08:54:44 GMT

Brilliant! Thanks for the feedback @Kallis