2 Replies Latest reply: Jun 15, 2011 7:08 PM by Angus Monro RSS

    field name

      After the initial LOAD.

       

      fv:

      LOAD *

      FROM

      [R:\FV.TXT]

      (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
          John Witherspoon

          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 [R:\FV.TXT] (txt, utf8, embedded labels, delimiter is '\t', msq);
              store * from fv into Data\Dimensions\fv.qvd;
          END IF

          • Re: field name
            Angus Monro

            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.