10 Replies Latest reply: Jul 21, 2016 3:55 AM by Alexander Steinhart RSS

    Load if not equal

    Alexander Steinhart

      Hello,

      I have a problem with my Skripting.

      I join two Tables to one.

      But I want only the elements, where the [Object-ID] is not included in Table1


       

      Aufgaben:

      LOAD [Object-ID],

           a,

      b

      FROM

      [..\10_Data\test.xlsx]

      (ooxml, embedded labels, table is Aufgaben);

       

       

      join load distinct

      [Object-ID],

         a,

      b

      FROM

      [..\30_QVDs\Aufgaben.qvd] where ...............

      (qvd);

       

      I hope someone can help me.


      Alex