Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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..
Good idea, but 'embedded labels' doesn't seem to affect the output file.