Same table

[johnan]

Hi All!

Ok, i have a table that i will merge, i think.

The first table is an orginal order (NOR), the CUST is customerOrderNumber.
The second table (Return) is the same table as the first but the fieldCustOrder is another field i table.

I now want the result to be:

Order 500344 to show the orginal from order 490761 (CustOrder in return to Order in Nor)

OrderTable1 NOR ORDER
ORDER	CUST
490761	5553436
490762	5553437
490763	5553438

OrderTable1 RETURN Order
ORDER	CUSTOrder
500344	5553436
500345	5553437
500346	5553438

Br John

[mikaelsc · Accepted solution]

i think you will join those tables. 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Orders:

load 

ORDER,

CUST

from OrderTable1 NOR ORDER;

outer join(Orders) //(or left or right or inner, depending on your objective)

load 

ORDER  as Return_Order,

CUSTOrder as CUST

from 

OrderTable1 RETURN Order;

(and yes, depending on what you want to achieve, there may be far better solutions)