topic Re: Transform data in Alteryx Designer Desktop Discussions

Transform data

ulrich_schumann — Tue, 07 May 2019 15:48:05 GMT

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,

Re: Transform data

afv2688 — Tue, 07 May 2019 16:11:31 GMT

Hi @ulrich_schumann

I think this will do it

Cheers

Re: Transform data

davidrioux — Tue, 07 May 2019 17:26:36 GMT

Hello: Another possible solution you can also check out.

Re: Transform data

gantaanvesh — Wed, 08 May 2019 17:25:44 GMT

Hi, can someone help me with transformation, am facing challenges to bring desired output.

Re: Transform data

ulrich_schumann — Wed, 08 May 2019 14:20:37 GMT

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.

Re: Transform data

gantaanvesh — Wed, 08 May 2019 14:24:57 GMT

Hi pfa sample data

Re: Transform data

gantaanvesh — Wed, 08 May 2019 17:17:36 GMT