Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qw_johan
Creator
Creator

Comparing

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

1 Solution

Accepted Solutions
Not applicable

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
];


View solution in original post

2 Replies
Not applicable

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
Creator
Creator
Author

Thank you so much! Big Smile