Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, i loaded the data from the erp with this script;
GECMIS_YILLAR_FIILI:
sql
select * from IFSAPP.SAMET_QLIK_FIILI_MALIYETLI
where yıl = '2015';
STORE GECMIS_YILLAR_FIILI INTO 'Q:\GECMIS_YILLAR_FIILI.qvd' ;
now i want to get the 2016 datas from erp, and aggregate this two data.
how can i write this script?
thanks
somar
Maybe something like this:
GECMIS_YILLAR_FIILI_2016:
sql
select * from IFSAPP.SAMET_QLIK_FIILI_MALIYETLI
// where yıl = '2016'; // unless year is really as string
where yıl = 2016;
STORE GECMIS_YILLAR_FIILI INTO 'Q:\GECMIS_YILLAR_FIILI_2016.qvd' (qvd);
drop tables GECMIS_YILLAR_FIILI_2016;
Load * From 'Q:\GECMIS_YILLAR_FIILI_20*.qvd' (qvd);
- Marcus
Maybe something like this:
GECMIS_YILLAR_FIILI_2016:
sql
select * from IFSAPP.SAMET_QLIK_FIILI_MALIYETLI
// where yıl = '2016'; // unless year is really as string
where yıl = 2016;
STORE GECMIS_YILLAR_FIILI INTO 'Q:\GECMIS_YILLAR_FIILI_2016.qvd' (qvd);
drop tables GECMIS_YILLAR_FIILI_2016;
Load * From 'Q:\GECMIS_YILLAR_FIILI_20*.qvd' (qvd);
- Marcus
Thank you so much Marcus Sommer