Exists function in load script

[MikeGaunt]

Hi 

I have two load scripts 

Table 1 

[Format]:
LOAD
	[SO],
	[Sales Document Item],
	[Material],
	[Item Description],
	[Item Qty],
	[Contract Admin],
	[Ship to Name],
	[Ship to Account],
	[Ship to City],
	[Ship To],
	[First Date],
	[Item Release Status],
	[Ship Request No],
	[Delivery Note],
    [SO]&[Sales Document Item] as UID
	
 FROM [lib://BI/GCO TAB.xlsx]
 
 (ooxml, embedded labels, table is Format)
 
 //   ADD FILTERS FROM gco report data to the where clause 
 //  [Item Release Status] = 'Not Released' - filters out orders that has not yet been released
 //  [First Date] <= today(1)+90 - limits the view to orders within the next three months.
 
Where

 [Item Release Status] = 'Not Released'
 
 and
 
 [First Date] <= today(1)+90
 
;

Table 2 

ZSHIP:

LOAD
    "Order",
    Item,
    "Order"&Item as UID2,
    "Delivery PGI date"
FROM [lib://BI/ZSHIP.xlsx]
(ooxml, embedded labels, table is Format)


// this is filtering out where shipments havent take place 


where

len("Delivery PGI date">1)

Now in theory the UID is the link between the two data sets however where the same value for UID and UID2 exists it does not need to be loaded .

How can I achieve this ? 

Note: I have only called the UID2 as if i call it UID Qliksense will auto link and then I cannot cut the data. 

TIA

[Dharanidharan_DD]

Hi @MikeGaunt,
You can have the same field two times in the above table. one for the link(UID)and the other with a different name for the 'Where not exists' below table.

[MikeGaunt]

Thanks, 

but where and how would the where exists be constructed if the link is already in place ?