topic Load From one table by values from another in QlikView

Load From one table by values from another

Wed, 24 Apr 2013 14:17:00 GMT

Hello all,

Let's say I have these 2 tables I'm loading from. Table 1 contains sales orders, and Table 2 contains item information.

Table 1 has an order with Items 123, 234, and 456. Table 2 has those items but a bunch more as well. The goal would be to load ALL records from Table 1, and only load the records from Table 2 where those item numbers match the sales orders from Table 1.

This is probably relatively easy to do but I can't seem to get it working right.

Thank you!

Re: Load From one table by values from another

alexandros17 — Wed, 24 Apr 2013 14:19:35 GMT

Table 1 ....

Left join

Table 2

in this way only values for table 2 corresponding to table 1 will be loaded

hope it hrlps

Re: Load From one table by values from another

Wed, 24 Apr 2013 14:22:27 GMT

By the way, I should have clarified I know I can do a left join or a left keep, but is there a more efficient way to do the load?

Re: Load From one table by values from another

Gysbert_Wassenaar — Wed, 24 Apr 2013 14:23:59 GMT

You can use left join or left keep depending on if you want one resulting table or two separate tables.

Table1:

Load * from ...sourcetable1;

Table2:

left keep

load * from ...sourcetable2;

Re: Load From one table by values from another

shree909 — Wed, 24 Apr 2013 14:36:48 GMT

I think

u need to make the left join

Example:

Table1:

load sales_order,

item

from file or database

left join(Table1)

load

item

from database or flatfile

by doing this u will get all the records from table 1 and only matching records from table2.

Hope this helps

Re: Load From one table by values from another

Wed, 24 Apr 2013 14:48:08 GMT

Hi,

You can also use exists() function for the same. Refer attached sample file.

SalesOrder:

LOAD * INLINE [

OrderNumber

123

234

456

];

SalesDetails:

LOAD * INLINE [

OrderNumber, OrderDetailNo, Amount

123, 1 , 100

234, 2 , 200

456, 3, 800

567, 5, 200

678, 6, 600

123, 2, 500

]

where exists(OrderNumber);

Regards,

Rahul