Discussion board where members can get started with QlikView.
After the initial LOAD.
(txt, utf8, embedded labels, delimiter is '\t', msq);
store * from fv into Data\Dimensions\fv.qvd;
I lilke to comment the above code and only LOAD from the qvd
I like to automatically grab the column names instead of typing out all the column names.
How can I do this?
I'm not sure quite what you want. Maybe this?
IF filesize('Data\Dimensions\fv.qvd') > 0 THEN fv: LOAD * FROM Data\Dimensions\fv.qvd (QVD);ELSE fv: LOAD * FROM (txt, utf8, embedded labels, delimiter is '\t', msq); store * from fv into Data\Dimensions\fv.qvd; END IF
I'm not quite understanding what you're after. I think it would help to
understand why you're wanting to avoid explicitly naming the columns
(and why you don't want to merely use '*' instead of listing the column