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;
