topic Re: load data from ERP over the previous data in QlikView

load data from ERP over the previous data

Wed, 25 Nov 2020 16:16:04 GMT

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 — Sun, 08 May 2016 09:26:00 GMT

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

Tue, 10 May 2016 21:56:04 GMT

Thank you so much Marcus Sommer