Error in script

[mario-sarkis]

while i am running the script an error appear (Script line error: let vQA) please find attach file. If you can tell why

Thanks

[rubenmarin]

Hi mario, is this the entire line in the script? "let vQA"?.

Most probably it's because you didn't end the previous sentence with a semicolon (;), otherwise must be something with that let sentence, if this is the case, I'll need to see the entire sentence in script.

[mario-sarkis]

Hi Ruben;

Once i click Releod the error appears. When i click ok the script run normaly.

anyway this my script :

CustomerValidationName:
NoConcatenate
LOAD
  CIFID ,
  CIFTYPE,
  CIFTYPE2,
  CIFSHRTNM
  
From $(vCustomersExtractionFile).qvd(qvd);
   

CustomerClas:
NoConcatenate
LOAD
CIFID as [AccID],
CIFTYPE as [Customer Val Type],
CIFTYPE2 as [Customer Val Type2],
CIFSHRTNM as [Customer Val Name]

Resident CustomerValidationName;
drop Table CustomerValidationName;

Derscriprion:
Load
CDSLONCDE,
CDSLONELM,
CDSLONTAB,
trim(CDSLONDES1) as CDSLONDES1
Where (CDSLONCDE='CIF' and CDSLONTAB='SE')  ;

SQL SELECT
CDSLONCDE,
CDSLONELM,
CDSLONTAB,
CDSLONDES1
FROM IASP1.VBAUMF.VCDSLON;

CustomerSegmentation:
NoConcatenate
Load
    CIFEXCLSE,
    CIFEXCOB,
    CIFEXGIIN,
    CIFEXID,
    CIFEXIN,
    IF(NOT ISNULL(CIFEXPEBA),CIFEXPEBA) AS CIFEXPEBA,
    CIFEXPEBR,
    CIFEXPOGCN,
    CIFEXPOMCN,
    CIFEXPOPCN,
    CIFEXPOSCN,
    CIFEXTFIL,
    CIFEXUPBA;

SQL SELECT
    CIFEXCLSE,
    CIFEXCOB,
    CIFEXGIIN,
    CIFEXID,
    CIFEXIN,
    CIFEXPEBA,
    CIFEXPEBR,
    CIFEXPOGCN,
    CIFEXPOMCN,
    CIFEXPOPCN,
    CIFEXPOSCN,
    CIFEXTFIL,
    CIFEXUPBA
FROM IASP1.VBKCIF.VCIFEXTPF;

CustomerSegmentation1:
NoConcatenate
Load
  CIFEXID as  [AccID],
  CIFEXCLSE,
  CIFEXPEBA,
  CIFEXPEBR
  resident CustomerSegmentation
where (CIFEXPEBR='023' or CIFEXPEBR='078');
drop table CustomerSegmentation;
rename table CustomerSegmentation1 to CustomerSegmentation;

CS:
Load
[AccID],
CIFEXCLSE as CDSLONELM,
trim(CIFEXPEBA) as CIFEXPEBA,
CIFEXPEBR
Resident CustomerSegmentation;
Drop table CustomerSegmentation;
rename table CS to CustomerSegmentation;

left join(CustomerSegmentation)
Load CDSLONCDE,
CDSLONELM,
CDSLONTAB
Resident Derscriprion ;
Drop table Derscriprion;

left join(CustomerSegmentation)
LOAD * Resident CustomerClas;
drop table CustomerClas;

Thank you

[rubenmarin]

Hi Mario, I didn't see any 'let' sentence here and I don't think it's part of vCustomersExtractionFile.

Can you double-check if there is a previous tab and/or hidden script where this sentence appears?. Maybe it's betwwen the firsts SET sentences in the Main tab.

To check if there is a hidden script you can check, insede the script--> file menu--> If the 'Edit hidden script...' option is active, there is a hidden script.

[mario-sarkis]

Hi Ruben this is what i have in the MAIN First Tab , and i dont have any hidden script.

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

$(include=../includes/QVD_Paths.txt);

Thank you

[awhitfield]

Check what's in the include file.

[rubenmarin · Accepted solution]

Yes, in ../includes/QVD_Paths.txt should exists that let, check if the previous sentence has his semicolon at the end or post the content of the file if vQA is calculated using previous variable values.

[mario-sarkis]

Thank you Ruben for Your help.

you were right had prob with ../includes/QVD_Paths.txt