Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
After the initial LOAD.
fv:
LOAD *
FROM
(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?
Thanks.
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
store * from fv into Data\Dimensions\fv.qvd;
END IF
Hi,
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
names).
Angus.