6 Replies Latest reply: Jul 31, 2018 11:09 AM by Vincent Bellanger RSS

    Trouble comparing 2 tables

    Vincent Bellanger

      Greetings,

       

      I'm trying to compare 2 tables which i created with this script:

       

      Argu:

      LOAD

          "Code système U-VM",

          "OS-VM"

      FROM [lib://AttachedFiles/VMWare.qvd](qvd)

      where wildmatch("OS-VM", '*Red*')=1;

      left join

      LOAD

          "Code système U-Name" as "Code système U-VM",

          [OS installé sur le serveur]

      FROM [lib://AttachedFiles/Isilog.qvd](qvd);

       

      Argu2:

      NoConcatenate

      LOAD *

      RESIDENT Argu;

      Drop TABLE Argu;

       

      It work well except that in table chart it give me this

      Capture.PNG

      But i'm not supposed to have those lasts field on the right my join was supposed to make appear only result that have a "Code système U-VM". Which is why i'm lost x_x