Join or Append?

[mherm]

Hello everybody,

I am quite new to Alteryx and i have a table which looks like:

NAME	Attr1	Attr2	Attr3	Attr4	Attr5
A	a	f	k	p	u
A	b	g	l	q	v
B	c	h	m	r	w
C	d	i	n	s	x
B	e	j	o	t	y

I want to group the name so that every name is unique and all of its attributes are in the same column:

A	B	C
a	c	d
f	h	i
k	m	n
p	r	s
u	w	x
b	e
g	j
l	o
q	t
v	y

I would be very happy if someone has an idea how to implement this as a worklfow in Alteryx?

Thanks in advance!

[jack_morgan · Accepted solution]

Hey mherm,

Full disclousure, this isn't a full solution but should get you going. Attached is a workflow that will get the data to where you want it but transposed. Take a look, I hope it helps!

Jack

[JohnJPS]

I got this working however needed to select out the columns by name; perhaps there's a better way, e.g. if you have lots of names.

I've attached the workflow.

[mherm]

Hey jack_morgan,

works perfect! Thank you for the quick response!

I combined it with  "Text to Columns" and now its exactly what I was looking for.

Thanks,

Michael

[mherm]

---

@JohnJPS wrote:

I got this working however needed to select out the columns by name; perhaps there's a better way, e.g. if you have lots of names.

I've attached the workflow.

---

Hi JohnJPS,

thanks for your solution. This works also but as you indicated its not practicable in case of many names which is also true for my specific case.

I used the solution of jack_morgan and combined it "Text to Columns".

Thanks

Michael