Incremental load previous 3 months

[bandarjm]

Need help where i am going wrong. correct me!!!

Need to load last 3 months incremental load . I will check daily and load previous 3 months data. 

should work for 2020 ,2021.,,

Condition i have is

let v3month=month (today())-3

Select * from table where year=VCurrrentYear and Month >= v3month

concatenate

Select * from CurrQVD where year=VCurrrentYear and Month <v3month

Store CurrQVD

[Prashant_N]

Hi,

Script looks ok.

please check the format you specified for month & year is same as present in the database.

If same then apply floor() on both the variables data.

Thanks & Regards,

Prashant