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!
Solved! Go to Solution.
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
@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