
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where not exists
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@PrashantRupani Remove the Concatenate(First) statement and drop the First table in the end

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@PrashantRupani Remove the Concatenate(First) statement and drop the First table in the end

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Kush. This worked.
