May be something like this:
LOAD * Inline [
Object 1, Local
Object 2, Local
Object 3, Global
LOAD ObjectName as ObjectName1
LOAD ObjectName1 as ObjectName,
'NULL' as Tag
Where not Exists(ObjectName, ObjectName1);
DROP Table Table1;
I am assuming you left joined table 1 with table 2. You can not further select into "-" unless you have a record for object 4 in table two.
An alternate way is the following:
assign your object4 a dummy value in the script, like I have attached. Please go through the script. !
qlik1.qvw 151.5 K