If you are wanting to make sure that you only load a value into your second table where the related Key1 value has already been loaded in your first table then use Exists(Key1)
Where not exists is a command you can use in order to exclude lines in your load. Although it seems you have a mistake in the script, as Marcus also mentions, the basic idea behind it is that you'll load everything from load 2, except the lines where Key1/A is similar to Key 1 from your Trans load.
You need to do the Trans load, in order for Qlikview to know the value you don't want to load in advance.
The really good thing about Where & Where Not Exists is that if you use one, & only one of them, then a load from a qvd file remains optimized, as in really really fast.
So one can, for example, load a calendar of just this year's dates and then do a Where Exists ([Date]) load on a transaction qvd with decades of data an only load what want whilst still optimized.
Not exists checks previously loaded data so it is checking Key1 in table 1 against key A in table two. If you only want to return rows in table two which do not match a value of Key1 in table one without joining the tables this would work.
Note: You did not need to create a second field called KeyA, the code will do the same thing this way not exists(Key1)
KeyA cannot be used in the WHERE clause of the second LOAD because KeyA does not exist until after the LOAD statement has been executed til the end. You will get a FieldNotFound error.
You are performing a WHERE NOT EXISTS from the same QVD as the first LOAD (xxxx.qvd). There is nothing more to add, when all rows have already been LOADed.
