hello, i have an issue i want to have the difference between data in same table but at different dates.
in 202101, i have 297600 values
in 202012, i have 296000 values
so i want the results to be the diffrences between the 2.
here is what i did :
F_ECT_ETAT_CONTRAT_deb: Load * Where not isnull([Valeur Acquise]) and [Code Mois Alimentation (AAAAMM)]='202101' and [Indicateur en cours] = 'O'; LOAD ECT_ADH_CLE, ECT_AGC_CLE, ECT_BT_ENCOURS as [Indicateur en cours], ECT_CD_MOIS_ALIM as [Code Mois Alimentation (AAAAMM)], ECT_CTR_CLE as ECT_CTR_CLE_deb, ECT_MT_VALEUR_ACQUISE as [Valeur Acquise], ECT_PRD_CLE FROM myfile.qvd (qvd);
F_ECT_ETAT_CONTRAT_fin: Load ECT_CTR_CLE, ECT_CD_MOIS_ALIM as [Code Mois Alimentation (AAAAMM)_fin], ECT_MT_VALEUR_ACQUISE as [Valeur Acquise fin], ECT_BT_ENCOURS as [Indicateur en cours fin] FROM myfile.qvd (qvd)
Where not isnull(ECT_MT_VALEUR_ACQUISE) and ECT_CD_MOIS_ALIM ='202012' and ECT_BT_ENCOURS = 'O' and not Exists(ECT_CTR_CLE_deb, ECT_CTR_CLE);
