field name

[Anonymous]

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.

[johnw]

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

[gussfish]

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.