Who ate my rows!

[JustinDallas]

Hello Everyone,

I am fighting a problem, and I am partly done with it.  However, I am confused about what is happening when I make a small change.  When I run my script like this, the resulting table is what I want.

a:
LOAD * Inline [
Username, Code, Blah, Cookies,
    1, a , 1 , 4
    2, b , 2 , 4
    3, c, 3 , 3
    4, d, 4 , 2
    5, e, 5 , 63
];


NoConcatenate
TableWithMissingDataAdded:
LOAD * Resident a
;
OUTER Join
LOAD * INLINE [
    Username, Code, Blah
    3, c, 3
    4, d, 4
    5, Seattle, Seahawks
    10, j, 10
    11, k, 11
]
where not exists(Username,Blah)
;


DROP TABLE a
;

BUT!  When I take that last "LOAD * INLINE.." and break it out into it's own table, my resulting table is missing {10,j,10} and {11,k,11}.  I'm not too sure what part of the process I'm not understanding correctly between the above code, and this code.  I assume something is being concatenated behind my back, but I don't know how to verify that with my little understanding..

Warning: Row Eater Below

a:
LOAD * Inline [
Username, Code, Blah, Cookies,
    1, a , 1 , 4
    2, b , 2 , 4
    3, c, 3 , 3
    4, d, 4 , 2
    5, e, 5 , 63
];


b:
NoConcatenate
LOAD * INLINE [
    Username, Code, Blah
    3, c, 3
    4, d, 4
    5, Seattle, Seahawks
    10, j, 10
    11, k, 11
]
;


NoConcatenate
TableWithMissingDataAdded:
LOAD * Resident a
;
OUTER Join
LOAD * Resident b
where not exists(Username,Blah)
;


DROP TABLE a
;
DROP TABLE b
;
DROP TABLE a

DROP TABLE b
;

What on earth is the difference between the two.

Any help is greatly appreciated.

[Anonymous]

When you use the Exists function you are saying where Username doesn't exist in Blah... I think that is causing your issue. This is directly from the help guide:

exists(IDnr, IDnr) returns -1 (true) if the value of the field IDnr in the current record already exists in any previously read record containing that field.

[MK_QSL · Accepted solution]

create a field as below in table a

Username&Blah as key

now use

Where note exists(key, Username&Blah);

[JustinDallas]

Thanks Manish! This was the answer.