topic Re: Difficulty in loading data in QlikView

Difficulty in loading data

surajrai — Thu, 23 Aug 2018 16:45:57 GMT

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

Re: Difficulty in loading data

andrey_krylov — Fri, 24 Aug 2018 03:14:51 GMT

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)

Re: Difficulty in loading data

surajrai — Fri, 24 Aug 2018 07:59:47 GMT

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.

Re: Difficulty in loading data

gawalimegha — Fri, 24 Aug 2018 11:02:34 GMT

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.

Re: Difficulty in loading data

surajrai — Sat, 25 Aug 2018 07:43:20 GMT

Hi Megha, thank you for your help.

Its a different way and a good one.