The following error occurred: Unexpected token: '12', expected one of: ',', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ... The error occurred here: MaxLoop: LOAD ACCT_SYSTEM_PORTF_NO_PERF, 6/28/2013 >>>>>>12<<<<<<:00:00 AM as ANALYSIS_DATE, BUSINESS_DATE_PERF, max([Comp PF Return]) as MaxCompPF, max([Comp BM Return]) as MaxCompBM, max([Comp Active Return]) as MaxCompAct Resident PERF_TEMP Where ANALYSIS_DATE<=6/28/2013 12:00:00 AM and BUSINESS_DATE_PERF='8/31/2020 12:00:00 AM' Group By ACCT_SYSTEM_PORTF_NO_PERF,BUSINESS_DATE_PERF Data has not been loaded. Please correct the error and try loading again.
Below is the script for the same.
Loop1: LOAD Distinct //ACCT_SYSTEM_PORTF_NO_PERF as PortLoop, ANALYSIS_DATE as AnLoop, BUSINESS_DATE_PERF as BDLoop
Resident PERF_TEMP Order By BUSINESS_DATE_PERF,ANALYSIS_DATE; // MonthNo>='$(vMaxMonth60)' and ACCT_SYSTEM_PORTF_NO_PERF,
let numRow= NoOfRows('Loop1');
sub Loop2
FOR i=0 to ('$(numRow)'-1);
//let vPort=peek('PortLoop',$(i),'Loop1'); let vBD=peek('BDLoop',$(i),'Loop1'); let vAD=peek('AnLoop',$(i),'Loop1');
if len('$(vAD)')=0 then EXIT Sub;
ELSE // MaxLoop: LOAD ACCT_SYSTEM_PORTF_NO_PERF, $(vAD) as ANALYSIS_DATE, BUSINESS_DATE_PERF, max([Comp PF Return]) as MaxCompPF, max([Comp BM Return]) as MaxCompBM, max([Comp Active Return]) as MaxCompAct Resident PERF_TEMP Where ANALYSIS_DATE<=$(vAD) and BUSINESS_DATE_PERF='$(vBD)' Group By ACCT_SYSTEM_PORTF_NO_PERF,BUSINESS_DATE_PERF; //and ACCT_SYSTEM_PORTF_NO_PERF='$(vPort)'
