Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Group By Value then move values to new columns

spdhg
5 - Atom

Apologies if this has been asked before/seems simple but for some reason I can't find a solution.

See before and after for what I'd like my data to look like:

 

Before:

AcctEmail
1234xyzxyz
1234abcabc
1234asdasd
5678tyui
5678qwer

 

After:

 

AcctEmail_1Email_2Email_3
1234xyzxyzabcabcasdasd
5678tyuiqwer[null]

 

Is there a simple workflow/tool to do this that can also automatically add and name columns?

 

Thanks!

2 REPLIES 2
ggruccio
ACE Emeritus
ACE Emeritus

Hi @spdhg,

 

It should work with a transpose then concatenate with a bit of logic built in between.  See example below..

 

ggruccio_0-1613757101327.png

Result:

ggruccio_1-1613757129436.png

 

spdhg
5 - Atom

That is both an elegant solution to the problem as well as a surprising revelation that a simpler tool wasn't available!

 

Either way solved the issue exactly as expected so thank you!

Labels