Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
7 - Meteor

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
7 - Meteor

Hi pfa sample data 

gantaanvesh
7 - Meteor
 
Labels