Hi all,
i need your support.
I have a table with some rows but i need to add new calculated rows.
This is my approch:
- i read the table
- i read for the second time this table with concatenate in order to add new rows calculated.
It seems to work but i find some rows without values into dimensions.
Thanks in advance for your help
Have a nice day
Mauro
This is the script
PRIMANOTA_TMP:
LOAD
CDC,
NR_CONTO_ANA,
_KPNUMREG,
PNCODCON,
Actual,
Budget,
ReferenceYear,
ReferenceMonth,
ReferenceDate,
Descrizione,
VOCE,
DESCRIZIONE_VOCE,
FILIALE
FROM [lib://Qlik App Data (gruppocbs_qservice-dev)/99.Shared_Folders/2.QVD/2.DW_Associative/PR_LOSS/PRIMANOTA.QVD]
(qvd);
Concatenate
LOAD distinct
CDC,
//KPNUMREG,
//PNCODCON,
if(match(NR_CONTO_ANA, '040120030','030105020','030105030'),'99999999') as NR_CONTO_ANA,
if(Actual >0,Actual*(-0.042),0) as Actual,
if(Budget>0,Budget*(-0.042),0) as Budget,
ReferenceYear,
ReferenceMonth,
ReferenceDate,
'Costi di sede' as Descrizione,
'021 COSTI DI SEDE' as VOCE,
'COSTI DI SEDE' AS DESCRIZIONE_VOCE,
FILIALE
RESIDENT PRIMANOTA_TMP;