Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Append rows as colums if ID is equal

BautistaC888
8 - Asteroid

Hello,
I have a Database similar to this

BautistaC888_0-1622660800375.png

And i want to transform it into this

BautistaC888_1-1622660845429.png

Appending the rows as columns if they are equal.
I added a workflow with the input and desired output.
Thank you.

1 REPLY 1
Emil_Kos
17 - Castor
17 - Castor

Hi @BautistaC888,

 

I think this solution should work for you.

 

The only downside is you need to manually arrange the column order but besides that, I think it works as you wish:

 

Emil_Kos_0-1622664432572.png

 

If this isn't good for you let me know. 

Labels