Same table

johnan — Sat, 16 Nov 2024 02:13:43 GMT

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

Re: Same table

mikaelsc — Mon, 14 Oct 2019 17:52:21 GMT

i think you will join those tables.

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

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)

topic Same table in QlikView

Same table

Re: Same table