i need your support in order to use many temp tables.
I have different kpis coming from different applications.
I would like to optimize these tables and the final result must be a single table with:
_Kfiliale, (branch)
ReferenceDate
Fact type ---> this dimension changes in relation to the different kpi
Fact (measure)
This is an example of a specific kpi
SELEZIONE_TMP:
LOAD _KFiliale, _KCod_causale, "TIPO ELAB TESTATA", ReferenceDate, "DESCRIZIONE CAUSALE", "IMPORTO TOTALE" AS "R&S", CODICE_DIVISIONE, "DESCRIZIONE DIVISIONE"
FROM [lib://Qlik App Data (gruppocbs_qservice-dev)/99.Shared_Folders/2.QVD/2.DW_Associative/RIC_SEL/FATTURE.qvd] (qvd) WHERE "DESCRIZIONE DIVISIONE" = 'Generalista' and "TIPO ELAB TESTATA" = 'I';
LOAD 'R&S' as "Fact type", [_KFiliale], ReferenceDate, SUM("R&S") AS "Fact" resident SELEZIONE_TMP group by [_KFiliale],ReferenceDate,"R&S"; Rename table SELEZIONE_TMP TO SELEZIONE;
After loading all kpi (coming from different reports) i would like to merge all in a single table using Concatenate.
Is it possible? ....and how many temp tables can i use?
My idea is:
i load the first table i manage it... and so on for the others.
the final instructions is to load, concatenate, to load and so on.
