Use existing table

[maxime66]

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.

[alexandros17]

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

[maxime66]

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 ?

[#4]

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.

[maxime66]

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

[Michiel_QV_Fan]

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

[maxime66]

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.

[Michiel_QV_Fan]

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