Who ate my rows!

JustinDallas — Thu, 19 Feb 2015 17:55:33 GMT

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.

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.

Re: Who ate my rows!

Anonymous — Thu, 19 Feb 2015 17:59:16 GMT

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.

Re: Who ate my rows!

MK_QSL — Thu, 19 Feb 2015 18:00:39 GMT

create a field as below in table a

Username&Blah as key

now use

Where note exists(key, Username&Blah);

Re: Who ate my rows!

JustinDallas — Thu, 19 Feb 2015 20:02:31 GMT

Thanks Manish! This was the answer.

topic Re: Who ate my rows! in QlikView

Who ate my rows!

Re: Who ate my rows!

Re: Who ate my rows!

Re: Who ate my rows!