topic Script in QlikView

Script

Fri, 27 Nov 2009 07:17:38 GMT

Hi everyone,

I'm new to QlikView; I find it very easy to use but I'm going nuts with the script part; maybe cause I can´t stop thinking in SQL mode 😞

I have to excel files to import. One of them has certain data about some customers, and the other one has data for all customers.

I load the first one and I need to load, from the second one, only the data of those customers that appear in the first excel files (this is to put it in a simple way; it's pretty more complex though)

Looks something like this:

excel1:

load.......

from "...........excel1.xls..."

excel2:

load......

from "........excel2.xls..."

help needed, please!!! I'm going really insane

Script

Anonymous — Fri, 27 Nov 2009 08:23:26 GMT

There should me some field in common in both tables which identify customers. Assuming it is CustomerID, the script may be like this:

excel1:
load
CustomerID,
...
from ...;
excel2
load
...
from...
where exists(CustomerID);

(Other solutions also posible.)

Script

Fri, 27 Nov 2009 11:40:43 GMT

or try this one

excel1:

load CutomerID,... , ... from file 1.xls;

left join(excel1)

load CustomerID,... ,... from file2.xls;

regards

peter