Difficulty in loading data

[surajrai]

Hi Everyone,

I am working with a data set which is giving me trouble in loading in qlikview.

Sample data:

Header 1	Header 2	Header 3
ABC	DEF	GHI
JKL	MNO	PQR

Header 1	Header 2	Header 3
STU	VWX	YZA
QPR	SEC	MIC

So, in a single excel file there are multiple times same headers along with spaces after every part is getting over. And now I am not able to write accurate code or use some function which will load the data with single header for all and no spaces in between.

Can anyone help or suggest something for the same?@Qlikhelp

[andrey_krylov]

Maybe something like this

LOAD  [Header 1],    

          [Header 2],

          [Header 3]

From SomeExcel

Where not IsNull([Header 1]) and [Header 1] <> 'Header 1' ... (and so on if necessary)

.

[surajrai]

Thank you Andrey for your help, half of the issue was resolved and for the other half I used Where IsNum (Header) = -1...
i got the solution, thanks.

[gawalimegha · Accepted solution]

Hello Suraj,

Here is Step by step procedure to achieve this.

Please find attached screenshots numbering per step along with .qvw.

Hope this help you.

[surajrai]

Hi Megha, thank you for your help.

Its a different way and a good one.