Load Statement Errors

Mon, 04 Feb 2013 15:51:44 GMT

I am having an issue getting this to load each time I reload I am getting this error:

Error: Syntax error, missing/misplaced FROM:

TBLSH_TD_TF:

LOAD 

 detailid AS[DETAILID],

  netgainid AS [NETGAINID],

 productcode AS [MATERIALNUMBER],

  quantity AS [QUANTITY],

  transdate AS [TRANSDATE],

 //Left(transdate,2) as [MONTH],

 //Right(transdate,4) as [YEAR],

  invoicecode AS [INVOICECODE],

  id AS [ID],

  custcode AS [VENDORCODE];



SQL select

      sh.detailid,

      sh.netgainid,

      sh.productcode,

      sh.quantity,

      sh.transdate,

  //convert(varchar, sh.transdate,110) as TransactionDate,

      td.invoicecode,

      tf.id,

      tf.custcode

 from tblTracingFile tf

 join tblTracingDetail td on td.FileID = tf.ID

 join tblsaleshistory sh on sh.detailid = td.ID

 where sh.TransDate between '10/1/2012' and '12/31/2012';

 

STORE TBLSH_TD_TF INTO ..\..\..\QVD\BU Reporting\IP\TBLSH_TD_TF.qvd;

Re: Load Statement Errors

Wed, 06 Feb 2013 18:41:38 GMT

I copied your script into notepad and noticed the following

detailid AS[DETAILID],

try giving space between AS and DETAILID

This should resolve your problem.

topic Re: Load Statement Errors in QlikView

Load Statement Errors

Re: Load Statement Errors