Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unpivot A Source Crosstab Table

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:

Crosstab Figure1.PNG

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

Crosstab Figure2.PNG

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.


1 Solution

Accepted Solutions
eduardo_sommer
Partner - Specialist
Partner - Specialist

Use Crosstable

CrossTable(Date, Forecast, 2)

Load *

From ...;

The from clause will specify the source file.

Eduardo

View solution in original post

2 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

Use Crosstable

CrossTable(Date, Forecast, 2)

Load *

From ...;

The from clause will specify the source file.

Eduardo

Not applicable
Author

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