Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Initally I was having a Cross Table data in excel like this below format and the QV script below,
Q1'15 | Q2'15 | Q3'15 | Q4'15 | |
IND | 68.2 | 72.3 | 77.3 | 82.2 |
USA | 40.5 | 42.9 | 45.9 | 48.8 |
JPN | 43.2 | 45.8 | 49.0 | 52.1 |
CAN | 25.5 | 27.0 | 28.9 | 30.7 |
AUS | 11.4 | 12.1 | 12.9 | 13.7 |
UK | 9.1 | 9.6 | 10.3 | 11.0 |
NZ | 2.3 | 2.4 | 2.6 | 2.7 |
The sript was like this below:
CrossTable(Quarter,Sales,1)
LOAD
Country,
[Q1'15],
[Q2'15],
[Q3'15],
[Q4'15]
From .........
Now the revised Cross Table format is like below, now we have Month field also below Quarter(Ignore the data please). How wil be the script for this to convert into a Straight table and load in QVD?
Regards!
You can use the Table Wizzard and set "Embedded Labels" and Header = 1 Line.
Give it a try
The data load wizard + crosstable wizard is probably best to help you. Here are some screenshots to help you: