LOAD RECORDS ADDED + NOT UPEDATED

[fmazzarelli]

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$]);

[Anonymous]

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.

[jagan]

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.