Hi,
I have fields like skey_date, month_offset,day_in_month_nr, if day_in_month_nr is 1 then I should get min(skey_date) only for month_offset=-1 or else then I should get min(skey_date) only for month_offset=0.
I tried using following in script it is not working:
if (day_in_month_nr)=1 then
LOAD min(skey_date) as date
FROM $(vQVDLib)date_dim.qvd (qvd)
where month_offset=-1;
else
LOAD min(skey_date) as date
from FROM $(vQVDLib)date_dim.qvd (qvd)
where month_offset=0;
end if
appreciatr all your help. Kindly provide me solution for this.
Awaiting your responses