how to remove multiple headings

[paulwalker]

Hi,

I have one excel file, page heading repeating in that data, how to remove that headings.

while data loading i need to remove those headings,

when i reload my data should be like,

ID	Name	Amount
100	ABC	100
101	BCA	200
200	sunil	3500
201	jkl	900
203	qwe	909
206	ggg	1234
500	Ramesh	890
450	Sam	230
780	Nari	735

Thanks in Advance.....

[Anonymous]

do the fieldnames of the heading change?

[sunny_talwar · Accepted solution]

May be like this

Table:

LOAD ID,

     NAME,

     AMOUNT

FROM ....

Where not Exists(ID);

[sunny_talwar]

or

Table:

LOAD ID,

    NAME,

    AMOUNT

FROM ....

Where ID <> 'ID';

[delmak2000]

Hi Paul,

I believe you could use a where clause to remove the multiple headings in the data when loading in qlikview...

Try...

LOAD

*

From yourdatapath/xlsx.(xlsx)

where ID <> 'ID'

Regards,

Ayo