We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
13 - Pulsar
13 - Pulsar

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