topic Re: how to remove multiple headings in QlikView

how to remove multiple headings

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

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.....

Re: how to remove multiple headings

Anonymous — Tue, 09 May 2017 17:40:21 GMT

do the fieldnames of the heading change?

Re: how to remove multiple headings

sunny_talwar — Tue, 09 May 2017 17:40:36 GMT

May be like this

Table:

LOAD ID,

NAME,

AMOUNT

FROM ....

Where not Exists(ID);

Re: how to remove multiple headings

sunny_talwar — Tue, 09 May 2017 17:41:16 GMT

or

Table:

LOAD ID,

NAME,

AMOUNT

FROM ....

Where ID <> 'ID';

Re: how to remove multiple headings

delmak2000 — Tue, 09 May 2017 17:42:09 GMT

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