Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Hi,
Try :
if vExists=NULL() or $(vExistsLen)<0 THEN
Hi,
Try :
if vExists=NULL() or $(vExistsLen)<0 THEN
Hi Brault,
Its working fine but I I would like to know what is the issue with above code?
Please explain me
Thanks,
Siva
I just figure out that you have to write vExistsLen as well after the or.
I can't technically explain you the "why". But from my experience, variables outside LOAD statement or functions should be used without the $()
hic could have an explanation ?
Thank you Brault
I am hitting same error.
Let vOrder = peek('Order',0,'loadTable');
Trace 'vOrder is ' $(vOrder);
If Not IsNull($(vOrder)) then
someLogicHere;
end if;
Getting error as below, I know, vOrder will be null at this stage, but code not going through.
Sorry, please ignore. Missed putting the solution provided. Did the same as suggested & it worked.