Hi i have this problem with my project, i think it DUPLICATE values, i think the problem is in CONCATENATE, using my QVD files:
IF filetime('.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd') > 0 then
CDG_Gas:
LOAD
NOME,
CONSUMO from '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd);
ELSE
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***:OLD;
STORE CDG_Gas INTO '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd);
ENDIF
IF filetime('.\DataStores\V_FATTURATO_CDG_GAS_19.qvd') > 0 then
Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO from '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd);
ELSE
Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***:19;
STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd);
ENDIF
Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***_20;
STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_20.qvd' (qvd);
ENDIF
Whei i go in my project if i look values in my Table all is ok, CONSUMO is with right value (25.000).
But when i see in the straight table chart the Sum(Consumo) make me values like are duplicate or similar (51.000)
If i delete all my QVD so it take values from database with SELECT all is ok, but when the second time i reload and it will take the rows from my QVD.... so now i have this problem
