topic Re: scripting temporary tables in QlikView

scripting temporary tables

clickertape — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: scripting temporary tables

jmvilaplanap — Thu, 20 Jul 2017 14:28:08 GMT

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

Re: scripting temporary tables

clickertape — Fri, 21 Jul 2017 08:30:17 GMT

thanks for this.

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

can they be named?

Re: scripting temporary tables

jmvilaplanap — Fri, 21 Jul 2017 09:18:36 GMT

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

Re: scripting temporary tables

clickertape — Fri, 21 Jul 2017 09:58:47 GMT

thanks Jose, i'll look into this.

ade