Comparing

[qw_johan]

Hi!

I am having problems comparing data, numbers and strings.
It's numbers that I am having problems with.
Qlikview thinks 0001 and 01 are the same.

[Missing in Tab1]:
LOAD *
Resident [Tab2]
Where not Exists([Tab1.ID], [Tab2.ID]);

Any thought on how to do the comparision?

Thanks

[#2 · Accepted solution]

QlikView thinks 0001 and 01 are the same because they are. Since they look like numbers, QlikView makes them numbers. Change your two original loads to force a string:

Tab1:
Load Text(ID) As ID, Name Inline [
ID, Name
0001, Carl
0201, Thomas
041017, Pete
080312, Sven
05, Carmen
0510, Tony
5010, Carlo
5101, Paul
2012, Hans
020120, Troy
0121, Michael
00010, David
];

Tab2:
Load Text(ID) As ID, Name Inline [
ID, Name
01, Carl
0201, Tomas
041017, Pete
080314, Sven
05, Carmen
0510, Tony
5010, Carlo
0521, Paul
2012, Hans
020120, Troyy
0121, Michael
00100, David
0711, Ben
9012, Tim
];

[qw_johan]

Thank you so much!