Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transform data

ulrich_schumann
8 - Asteroid

Hi *,

we receive on a regular basis an Excel file that I need to restructure in order to further process the data. I have tried with the transpose tool, but got problems with the given structure.

Year is given in a combined cell only once per value. Quarter might be sightly different written per year. The enclosed Excel shows in the "source" tab an example of the data and in the "target" tab the desired solution. Any suggestion how to get this transformed?

Thanks,

6 REPLIES 6
afv2688
16 - Nebula
16 - Nebula

Hi @ulrich_schumann 

 

I think this will do it

 

Cheers

davidrioux
5 - Atom

Hello: Another possible solution you can also check out.

gantaanvesh
8 - Asteroid

Hi, can someone help me with transformation, am facing challenges to bring desired output.Screenshot (56).pngoutlook.JPG

ulrich_schumann
8 - Asteroid

Hi @gantaanvesh ,

it is very helpful to upload sample data so that people can work on a solution. From my experience, without data is is unlikely to get an answer.

gantaanvesh
8 - Asteroid

Hi pfa sample data 

gantaanvesh
8 - Asteroid
 
Labels