topic TEMPORAL TABLES in QlikView

TEMPORAL TABLES

Wed, 17 Feb 2010 01:55:49 GMT

Hi,

Anyone can give me a little explanation on how can i make temp tables on qv script plz?, or how can i handle sql temp tables on the qv script plz.

Any help will be appreciate.

Carlos

TEMPORAL TABLES

johnw — Wed, 17 Feb 2010 02:21:09 GMT

Here is an example of creating a temp table from an SQL temp table, if I understood your question:

MyTempTable:
LOAD *
;
SQL
SELECT Z, A, B, A+B AS C FROM (
SELECT Z, MAX(ABC) AS A, SUM(XYZ) AS B
FROM some table
WHERE some condition
GROUP BY Z ) AS TEMPTABLE
;
...
Do things with MyTempTable
...
DROP TABLE MyTempTable
;

TEMPORAL TABLES

Wed, 17 Feb 2010 02:33:20 GMT

Thanks a lot John, you were very helpful.

Regards

CArlos

TEMPORAL TABLES

Wed, 17 Feb 2010 02:53:51 GMT

Hi, Carlos.

In the other way, you can create temp tables witch "Load InLine ..." statement manually.

This is only usefully for short quantity of data. For example you can make something like this


TempTable:
Load * inline
[campo1texto,campo2numero,campo3texto
"1",1,"texto1"
"2",2,"texto 2"
];

Re:TEMPORAL TABLES

Wed, 17 Feb 2010 03:12:28 GMT

Hi Carlos,

Thanks for your post.

Regards

Carlos