topic Re: field name in QlikView

field name

Anonymous — Wed, 15 Jun 2011 20:34:12 GMT

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.

Re: field name

johnw — Wed, 15 Jun 2011 23:00:17 GMT

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

Re: field name

gussfish — Wed, 15 Jun 2011 23:08:46 GMT

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.