Where not exists

[PrashantRupani]

Hi,

I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script. 

Below is the pseudo-code I found on internet and I tried executing this code in QS . The result doesn't make  sense to me. 

First:
Load F1 As F1Reduce, F2;
LOAD * INLINE [
F1, F2
1, North
2, South
];

Concatenate(First)
LOAD * INLINE [
F1, F2
1, North
2, South
3, West
4, East
3, West1
4, East1
]
where not Exists(F1Reduce,F1); //Loads records where F1's value not present in Table : First

drop Field F1Reduce from First;

The output I get is 

I am not expecting the above output. What I am expecting is East, East1, West , West 1. How do I modify the script?

My lack of understanding of NOT Exists is not helping me. 

[Kushal_Chawda · Accepted solution]

@PrashantRupani  Remove the Concatenate(First)  statement and drop the First table in the end

[PrashantRupani]

Thanks Kush. This worked.