topic Re: Use existing table in QlikView

Use existing table

maxime66 — Fri, 13 Feb 2015 16:48:32 GMT

Hi,

In script , I know that we can Load external tables (qvd,csv ...),also resident tables (created before in script) ,

but can we also load Tables that already exist in qlikview ?

Thanks for your help.

Re: Use existing table

alexandros17 — Fri, 13 Feb 2015 16:51:17 GMT

Sorry but where? The one that exists in qlik are those created in the script.

Re: Use existing table

maxime66 — Fri, 13 Feb 2015 16:56:09 GMT

It 's true for first Reload,

but after that tables are in the file ...

how to catch them into script when a second Reload for exemple ?

Re: Use existing table

Fri, 13 Feb 2015 18:43:10 GMT

Hi,

To read tables that exist in a qvw, you may want to try the binary load.

In a new qvw, from the edit script window you can click on "QlikView File".

After selecting the file, you'll get a statement at the beginning of the script: Binary filepath\filename.qvw;

This will load all the tables from filename.qvw into the new qvw and you can treat them all as "resident" tables.

Re: Use existing table

maxime66 — Mon, 16 Feb 2015 08:35:46 GMT

Hi thanks,

The think is that i want to use table that are in the same Qlikview that the script.

I'm looking to the "From_field" command , that is suppose to do that...but still testing

Re: Use existing table

Michiel_QV_Fan — Mon, 16 Feb 2015 09:12:19 GMT

Are you looking for the lookup function? Then you can reference another field and table.

Re: Use existing table

maxime66 — Mon, 16 Feb 2015 09:19:59 GMT

Maybe an example is better.

We want to know Each Monday the number of Emails that we have on our customers.

So we refresh a Qlikview each monday that Load an Excel File.

The think is that we want to keep a Tracking of this number (to see the evolution in time), and add a new line in the "Email_OK" table (with date of refresh.)

I thought to Load the "Email_OK" table in script (already existing in the Qlikview) and concatenate with a new line.

A solution could be to store a qvd or txt file in a directory,but we want to do this this in the Qlikview file.

Thanx for your help and time.

Re: Use existing table

Michiel_QV_Fan — Mon, 16 Feb 2015 12:24:24 GMT

Correct me if I'm wrong. This is what I understand from your email:

You load 1 excel each monday in which no historical data is stored?

In that case you could do an initial load and after that change the script to an add load script.

Using the function now as a timestamp as a field will generate separate lines in your QlikView table.

Like this:

add load

now() as Timestamp,

your excel lines go here

from ..... xls