QVD Issue

[VishalWaghole]

Hi Guys

Please anybody tell me, How can we use 3rd rows as header row from QVD.

Like we use from excel as

(biff, embedded labels, header is 3 lines, table is [Canada & Asia actuals$]);

But i dnt knw how can from qvd, so please if anyone no then tell me.........

Thanks,

Vishal Waghole.

[Miguel_Angel_Baeyens]

Hi Vishal,

A QVD file stores only one table, so the header line should be the first one. Anyway, if you don't want to load the first 3 lines (for example), you can do as follows:

Table:
LOAD *
FROM File.qvd (qvd)
WHERE RecNo() > 3;

Hope that helps.

Miguel

[VishalWaghole]

Miguel,

But result is not come as same as when i extract Data by using Excel

Thanks,

Vishal

[Miguel_Angel_Baeyens]

Hi Vishal,

Well, Excel and QVD formats are completely different. Can you please elaborate on your actual requirement? Are you sure that the QVD has 3 header lines (which to me seems pretty unusual)?

Miguel

[VishalWaghole]

Hi Miguel

I attached here My Excel file image, from that excel i create d QVD. In Our QVW Application perviousely we used excel but now we want to replace that excel to qvd. In perviouse QVW thr is code

LOAD Region,

     Category,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[Data.xls]

(biff, embedded labels, header is 3 lines, table is [Canada & Asia actuals$]);

that means header line is 3 without deleting 1st 2 line.

same logic i want for qvd which i created from data.xls excel.