Changing header size of QVD

[adnan_rafiq]

Hi Gurus,

Is there a way that we can possibly change the header size of a QVD?, all views appreciated.

[swuehl]

Could you elaborate further on what you envision here?

Do you want to enlarge or shrinken the header size?

Any specific elements?

Maybe have a look at

Re: Large number of irrelevant entries in QVD MetaData header

QVD File Size in QV11

[adnan_rafiq]

My vision is, that i have a qvd and in order to crosstable it, I use its given header, but I need to crosstable it again in order to load the 2nd header for that I need to change the header line.

[jonathandienst]

It still not very clear what you need. Perhaps you can supply a a sample QVD and a detailed explanation of the result you need.

[adnan_rafiq]

Here is the sample QVD. I want the desired result to be like the picture below. The way i tried to get this was by 2 crosstables one for month value and other for Department value. As month was captured by first cross table but to capture the dept need help to change the header line and then crosstable is to capture Dept values. I hope I am making my point clear

[swuehl]

I think the best way to achieve what you want is to correct the load script that generated this QVD.

Could you post the script that created the table that was stored into the QVD? Or the source table file?

[Anonymous]

You could extract things from the qvd with something like the below and then attempt to do some jiggery pokery to get it how you want it.

But as suggested above it would be a quicker and more robust to sort [CT solution.qvw] that created

QvdFieldHeader:

load

  Rowno() as DateColumnNumber ,

  date ( floor ( FieldName ) ) as DateHeader

where not match ( FieldName , 'F1' , 'F2' )

;

LOAD FieldName

FROM Initial.qvd (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

LOB:

LOAD F1,

     F2,

     [42430.000000],

     [42430.0000001],

     [42430.0000002],

     [42430.0000003],

     [42401.000000],

     [42401.0000001],

     [42401.0000002],

     [42401.0000003]

FROM

Initial.qvd

(qvd)

Where F1 = 'LOB'

;

qualify * ;

Data:

LOAD 

     [42430.000000],

     [42430.0000001],

     [42430.0000002],

     [42430.0000003],

     [42401.000000],

     [42401.0000001],

     [42401.0000002],

     [42401.0000003]

FROM

Initial.qvd

(qvd)

Where not F1 = 'LOB';

Dept :

LOAD 

     F1,

     F2

FROM

Initial.qvd

(qvd)

Where not F1 = 'LOB';

[adnan_rafiq]

Hi swuehl‌ . Here is the script and xls.

Initial:

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null)),

Transpose()

));

STORE Initial into Initial.qvd(qvd);

Drop Table Initial;

[adnan_rafiq]

But to my earlier question. can i change the header lines of a qvd?

[swuehl]

I'm unsure what you mean with 'header lines' here.

Don't you want to manipulate records in the table (i.e. cell (2,1), (2,2)), not the header?