topic Re: Join or Concatenate? in QlikView

Join or Concatenate?

Tue, 04 Jun 2013 22:23:25 GMT

Hey everybody i have this problem.

What's the difference between join and concatenate? Is this example OK? it's OK ib both ways?

Suppose i have 3 tables ALREADY created. Cust_Seller , Orders, Stock

Cust_Seller:

LOAD

Cust_ID,

Seller_ID,

Key

Orders:

LOAD

Order_ID,

Order_Articule

Order_Date,

Key;

Stock:

LOAD

Stock_ID

Order_ID,

Stock_Quantity,

Stock_Local;

What i want is to put in table "Cust_Seller", the STOCK_ID. so first i have to join ORDERS with Cust_Seller, put the Order_ID, and then join Stock with Cust_Seller, putting ONLY the Stock_ID (and relationing them with order_ID). Its OK????

Using join:

left join (Cust_Seller) // I only add Order_ID in Cust_sellers Table.. for those "Key" that matches?

load

Key,

Order_ID

Resident Orders;

left join (Cust_Seller) // I only add Stock_ID in Cust_Sellers Table.. for those orders that macthes the previous orders added??

load

Order_ID,

Stock_ID

Resident (Stock)

Its OK????

Using Concatenate

LOAD

Key

Resident Cust_Sellers

CONCATENATE // Here im adding all the orders_ID? I put distinct, in order to not aggregate same Keys as i had in the other table?

DISTINCT LOAD

Key

Order_ID

Resident Orders

LOAD

Order_ID

Resident Cust_Sellers

CONCATENATE // Here im adding all the Stock_ID? I put distinct, in order to not aggregate same orders as before...?

DISTINCT LOAD

Order_ID

Stock_ID

Resident Stock

Its OK???

Whats the difference between both?

If anyone can help me wi the 2 versions i woul appreciate a lot!

Licha. Thanks!

Re: Join or Concatenate?

laujerry — Wed, 05 Jun 2013 01:53:35 GMT

u may take a look with this: http://community.qlik.com/thread/39177

Re: Join or Concatenate?

Wed, 05 Jun 2013 04:21:27 GMT

Yeah, i've got it.. i understand now the difference but don't know how to apply them when i have 3 tables like in this example, and i want to put "things" from table 1 to table 3 passing through table 2.

Thanks!

Re: Join or Concatenate?

Wed, 05 Jun 2013 05:52:40 GMT

Hi Licha,

Try This hope it is heplful else upload your sample app.

Cust_Seller:

LOAD

Cust_ID,

Seller_ID,

Key

left join

Orders:

LOAD

Order_ID,

Order_Articule

Order_Date,

Key;

left join

Stock:

LOAD

Stock_ID

Order_ID,

Stock_Quantity,

Stock_Local;

Re: Join or Concatenate?

Wed, 05 Jun 2013 22:26:49 GMT

Hey, first, thanks for answering!

It Compiles but then it doesn't work properly (maybe i didn't explain what i want very well)

I put here the cvs and 2 images of the initial and final situation. I hope u can help me to solve this

http://bitshare.com/files/75vqgvm8/EXAMPLE.rar.html

Thanks very much!