topic Re: Load Script problem in QlikView

Load Script problem

saumyashah90 — Tue, 27 Aug 2013 12:02:28 GMT

I have two table,table A and table B

table A has one field called ID,and many other fields.

table B also has a field called ID

Now i want to load data from table B whose ID are equal to ID's of table A.

This is because table B has loads of data and i want only those whose ID matched with ID in table .
How should i do it?

Re: Load Script problem

marcus_malinow — Tue, 27 Aug 2013 12:04:35 GMT

Hi Saumya,

I'd suggest using the Exists clause.

So, for example

tableB:

LOAD ID,

field2,

etc...

WHERE Exists(ID)

FROM....;

Marcus

Re: Load Script problem

tresB — Tue, 27 Aug 2013 12:09:36 GMT

Try something like this:

tableA:

LOAD ID

FROM....;

tableB:

LOAD ID,

field3,

....

WHERE Exists(ID)

FROM....;

Drop table tableA;

Re: Load Script problem

CELAMBARASAN — Tue, 27 Aug 2013 12:15:41 GMT

Hi,

You can also try with Keep

tableA:

LOAD ID

FROM....;

tableB:

Left Keep(tableA)

LOAD ID,

field3,

....

FROM....;

hope it helps

Celambarasan

Re: Load Script problem

suniljain — Tue, 27 Aug 2013 12:27:07 GMT

Please use inner join .

QVTable:

SQL SELECT * FROM table1;

inner join SQL SELECT * FROM table2;

Re: Load Script problem

er_mohit — Tue, 27 Aug 2013 12:52:44 GMT

Try this

TableA:

ID,

Field1,

Field2

from TableA;

Inner Join

Load ID,

Field3,

Field4

from TableB;

hope it helps