Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the follwing script
AsOfMonth:
load 'Current' as Type,
Month as Month_AsOf,
Month as Month
Resident SalesData;
Concatenate (AsOfMonth)
load 'Rolling 3' as Type,
Month as Month_AsOf,
Month + 1 - IterNo() as Month
Resident SalesData
where promo =1
while IterNo() <= 3//here my problem
;
How to correct it ?
try like this
while (IterNo() <= 3 and promo =1) ;
I think you can either use a WHERE or a WHILE clause in the same LOAD statement.
If you want to use both clauses, you would need separate / preceding LOAD statements.