4 Replies Latest reply: Jun 13, 2018 1:15 PM by Siva Sankar Boggarapu RSS

    The following error occurred: Unexpected token: '=', expected one of: '

    Siva Sankar Boggarapu

      Hi Team,

       

      I am running the below script. But, I am getting below error. Could some one help me on the below error code?

       

      AWSDetaiQVD:

      LOAD

          InvoiceID,

          PayerAccountId,

          LinkedAccountId,

          LinkedAccountName,

          ProductCode,

          RecordType,

          RecordId,

          ProductName,

          RateId,

          UsageType,

          Operation,

          AvailabilityZone,

          ItemDescription,

          UsageStartDate,

          UsageEndDate,

          UsageQuantity,

          BlendedRate,

          BlendedCost

      FROM [lib://QVD/AWSDetail.qvd](qvd)

      where Exists(InvoiceID);

       

      Let vExists=Peek(InvoiceID,$(vNoRows)+1,'Billing');

       

       

      Let vExistsLen=Len(trim(Peek(InvoiceID,$(vNoRows)+1,'Billing')));

       

       

      if $(vExists)=NULL() or  $(vExistsLen)<0 THEN

       

      drop table Billing;

       

      The following error occurred:

       

      Unexpected token: '=', expected one of: '(', 'ZTestw_z', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'not', 'bitnot', 'LITERAL_NUMBER', ...

       

       

      ---

       

       

      The error occurred here:

       

       

      if >>>>>>=<<<<<<NULL() or 0<0 THEN