Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Split data in multiple tables

tanja90
7 - Meteor

Hello,

 

I have input like in example excel (sheet: "old") and I want to create output like in sheet "new".  Values for column Years is not fixed, I'm expecting values for additional years. But I don't know how to do it, any help would be great.

 

Thank you for your time.

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova
PhilipMannering
16 - Nebula
16 - Nebula

Hi @tanja90 

You could do something like this,

PhilipMannering_0-1606900374645.png

 

tanja90
7 - Meteor

Hi @PhilipMannering 

 

awesome, that's it!

Thanks a lot 🙂

atcodedog05
22 - Nova
22 - Nova

Hi @tanja90 

 

Just a slight modification to @PhilipMannering to match headers as expected output

 

Output:

atcodedog05_0-1606901005995.png

 

Hope this helps ðŸ™‚

 

tanja90
7 - Meteor

@atcodedog05 

 

Thank you 🙂

Labels