load data from ERP over the previous data

[#1]

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

[marcus_sommer · Accepted solution]

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

[#3]

Thank you so much Marcus Sommer