1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| if not isNull(QvdCreateTime('TonFichierQvd.qvd')) then
Table_1:
load C_ID,
TAUX,
DATE
FROM TonFichierQvd.qvd.qvd(qvd)
where DATE>=Date(AddMonths(MakeDate(Year(today()),Month(today()),1),-15),'YYYY-MM-DD')
;
Concatenate
LOAD C_ID,
TAUX ,
Date(makeDate(left(DATE,4),Right(DATE,2),15),'YYYY-MM-DD') as DATE
FROM TonFichierExcel.xls;
else
Table_1:
LOAD C_ID,
TAUX ,
Date(makeDate(left(DATE,4),Right(DATE,2),15),'YYYY-MM-DD') as DATE
FROM TonFichierExcel.xls
end if
STORE Table_1 INTO TonFichierQvd.qvd; |
Partager