Qlikview is joining 'in memory tables' on keys that have the same name.
I would like to analyze data splitted by minutes. As soon as splitting data while loading the script may generate a very large amount of data, I would like to know if there is another way to do it.
I imagine that it could be possible to load 'not splitted data' and then split it only according to selections operated.
In the example herejoined, two tables are loaded (BY_MINUTE and MINUTES) that could have been loaded with a join like :
select a.CLE, b.HEURE, b.NUM_MINUTE_JOUR, from DWH_AGENT_ENGAGE_J a inner join DWH_HEURES_MINUTES b on b.NUM_MINUTE_JOUR between a.NUM_MINUTE_DEBUT and a.NUM_MINUTE_FIN
But such a scfript would generate a too large amount of data even for a short period.
Is it possible to proceed to such an analysis while using inter records functionalities instead of loading all that data ?
