Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading QVD with Header Row

In brief, I have a text file with metadata and a text file with data. I want to load these into Qlikview, but don't see an elegant wizard to do such a thing. I've heard QV10 has metadata handling capabilities, but have not found them. Hence, my approach is as follows:

I have created a QVD by Storing two Concatenated text files, the first is a single row with Field names and the second is the actual data (without field names). When I subsequently Load this QVD, there is no option to say this QVD has Embedded Labels (actually there is, but it is nonfunctional). The loaded data is then in the form of "@" Field names, with the first row being the header and the second row starting the data.

As an aside, I can successfully Store the file into a text file and reload. But I'd rather Store a QVD so I can reload an Optimized QVD for faster processing.

Has anybody else used this approach, or know anything about metadata handling?

2 Replies
Not applicable

Re: Loading QVD with Header Row

Hi,

try this as your Store command for creating qvd

STORE ABC into ABC.qvd(qvd,embedded labels);

Let me know this works or not

Regards..

Not applicable

Re: Loading QVD with Header Row

Good idea, but 'embedded labels' doesn't seem to affect the output file.

Community Browser