remove unwanted headers

[#1]

Dear Experts,

           I would like to remove unwanted headers in the below table while using cross table.

I want to remove QWT Budget without deleting in source table. The headers are Office,EmployeeID,2008,2009,2010,2011,2012 by using cross table. how to do like below?

Budget:

CrossTable(Budjettivuosi, BudjetoituMaara, 2)

LOAD Office,

     EmployeeID,

     2008,

     2009,

     2010,

     2011,

     2012

FROM

[..\Developer\Datasources\Budget.xls]

(biff, embedded labels, header is 1 lines, table is Sheet1$, filters(

Replace(1, top, StrCnd(null))

));

Best Regards,

Kyaw

[tresesco]

May be like:

CrossTable(Year, Data, 2)

LOAD Office,

     EmployeeID,

     [2008],

     [2009],

     [2010],

     [2011]

FROM

[....\Book1.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

[#3]

hi tresesco,

     can i know how to filter the unwanted header in cross table step by step?

Regards,

Kyaw

[jonathandienst]

Without a sample of your spreadsheet, anything more than what tresesco has already said will just be guesswork...

[prma7799 · Accepted solution]

Go to > Tables files

> select files which you want to do changes

>Next

> Enable Transformation Step

> select row which you want to delete

>select Delete Marked Option

> Next

> Finish

[Peter_Cammaert]

If your QWT Header numbers only one row, it should work as-is by way of the "header is 1 lines" option. Remove the filters(Replace()) option and try again.

The input file is first treated with the options you set in the initial LOAD dialog which contains - amongst others - a header type selection list ("Lines") and an input field to enter the number of header lines. Only then is the pivoting (CROSSTABLE) applied.

Peter

[#7]

hi qlikview7799,

       It work well. thanks for your help.

regards,

Kyaw

[prma7799]

Hi Kyaw,

Most Welcome.

Thanks