scripting temporary tables

[clickertape]

in mysql, you create a temporary table in the db and then the data from the select statement automatically drops into it. this may happen more than once with many temp tables.

these tables can then be linked and an overall select statement pulled from them at the end.

can qlikview scripting perform something similar to this? do you utilise qvd files and then link them somehow?

newbie to scripting so apologies if this is an easy solution.

ade

[jmvilaplanap]

Hi

When you load a table in Qlikview, automatically it converts in Resident table, is in memory and you can use it without problem.

QVD is to store the table in a file.

Regards

[clickertape]

thanks for this.

if they're all resident, how would you perform linking to pull out overall data?

can they be named?

[jmvilaplanap]

Hi

You can name any table, here you have a little explanation: Loading data from a previously loaded table ‒ QlikView

[clickertape]

thanks Jose, i'll look into this.

ade