topic Re: Unpivot A Source Crosstab Table in QlikView

Unpivot A Source Crosstab Table

Mon, 30 Jun 2014 19:29:19 GMT

Hi all,

I need your help to unpivot a crosstab table source file and once it is unpivoted, I need to load it as a regular table.

My source file looks similar to the picture below:

What I need to do is to is transpose or transform the data so that it looks like the figure below:

I am also including a sample dataset so you can you it as the source for your solution.

Thanks in advance for all your assistance and support.

eduardo_sommer — Mon, 30 Jun 2014 19:37:43 GMT

Use Crosstable

CrossTable(Date, Forecast, 2)

Load *

From ...;

The from clause will specify the source file.

Eduardo

Mon, 30 Jun 2014 20:00:29 GMT

Eduardo, thanks for your all your help. The simple solution solved our problem.