2 Replies Latest reply: Feb 14, 2011 12:53 PM by Johan Adolfsson RSS

    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

        • Comparing
          Neil Miller

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