Error in Additional Script(loop)

[oehizele]

Hi, can someone please point out the reason for this script producing error

[tmp]: noconcatenate
Load * Inline
[_ReferenceID
];

//looping through for multiple stores
FOR dlr=0 to $(vQVDCount)

let vFixedOpsDivision = peek('FixedOpsDivision',$(dlr),'QvdDivisions');
let vContactDivision=peek('ContactDivision',$(dlr),'QvdDivisions');let vVehicleDivision=peek('VehicleDivision',$(dlr),'QvdDivisions');

if not isnull(qvdcreatetime('$(vQvdRoot)$(vGroupFolder)/QvdData/$(vQvdSerial)_RepairOrderCalc.qvd')) then
concatenate ('tmp')
Load
'$(vQvdSerial)/' & upper(purgechar(fldID,'{}')) as _ReferenceID,
fldCustServiceFee
from '$(vQvdRoot)$(vGroupFolder)/QvdData/$(vQvdSerial)_RepairOrderCalc.qvd' (qvd)
where match(fldDivision,$(vFixedOpsDivision));

end if

Next

//update RepairOrder Summary table to include CustServiceFee
left join ('RepairOrder Summary')

Load
_ReferenceID,
fldCustServiceFee as [RepairOrder Summary.fldCustServiceFee]
resident [tmp];

drop table [tmp];

[Kushal_Chawda]

@oehizele  what is the error? can you share log?