2 Replies Latest reply: Nov 2, 2015 10:03 PM by jagan mohan rao appala RSS

    LOAD RECORDS ADDED + NOT UPEDATED

    Fabio Mazzarelli

      Hi Community,

       

      i'm studying a script but i receive error in blue line.

       

      Could you help?

       

       

      //Load the records that have been added

      noconcatenate users:

      LOAD id,

           username,

           [license type],

           created,

           modified

      FROM 'lib://qvd data/inc_qvd.xls'

      (biff, embedded labels, table is [Sheet1$])

      where modified  > '$(user_modified_maxdate)';

       

       

      //Load records that have not been updated from the qvd

      //This can be taken from the QVD or Resident table

      UNQUALIFY *;

      users:

      Concatenate LOAD *

      FROM 'lib://qvd data/users.qvd'

      WHERE NOT Exists(id);

       

       

      INNER JOIN

        LOAD id FROM

        'lib://qvd data/inc_qvd.xls'

        (biff, embedded labels, table is [Sheet1$]);

        • Re: LOAD RECORDS ADDED + NOT UPEDATED
          David Capan

          you have an unqualify statement on top of that load.  Is the table where you are loading 'id' qualified?  If so, that's why you are getting the error: The table name is coming before the field.

          • Re: LOAD RECORDS ADDED + NOT UPEDATED
            jagan mohan rao appala

            HI,

             

            Try this script

             

            UNQUALIFY *;

            //Load the records that have been added

            users:

            noconcatenate

            LOAD id,

                 username,

                 [license type],

                 created,

                 modified

            FROM 'lib://qvd data/inc_qvd.xls'

            (biff, embedded labels, table is [Sheet1$])

            where modified  > '$(user_modified_maxdate)';

             

            users:

            Concatenate LOAD *

            FROM 'lib://qvd data/users.qvd'

            WHERE NOT Exists(id);

             

             

            INNER JOIN

              LOAD id FROM

              'lib://qvd data/inc_qvd.xls'

              (biff, embedded labels, table is [Sheet1$]);

             

            Regards,

            Jagan.