6 Replies Latest reply: Jul 21, 2015 10:20 AM by Mathieu LAURIER RSS

    Recherche

      Hello,

      would you help me to correct this codes? Thank you first!

      the goal is to have a table as:

      TNom1, TNom2

      AA, AA CC DD

      ABAA, AB

      AA CC, AA CC DD

       

      I have to use the method following (do while), because, the truth datas are too big, I can't use "left join".

      the second do while can't work, j=1 always.

       

      T1:

      load * inline [

      Nom1,

      AA,

      ABAA,

      AA CC

      ]

      ;

       

      T2:

      load * inline [

      Nom2,

      EE,

      AB,

      AA CC DD

      ]

      ;

       

       

      let i = 1;

      do while i<=3

          let j = 1;

          do while j <=3

              T:

              load

              peek(Nom1, $(j), 'T1') as TNOM1,

              peek(Nom2, $(j), 'T2') as TNOM2

              Resident T1

              where index( peek(Nom1, $(i), 'T1'), peek(Nom2, $(j), 'T2'), 1) >0 or index( peek(Nom2, $(j), 'T2'), peek(Nom1, $(i), 'T1'), 1)>0 ;

          j = j+1;

          loop 

      i = i+1

      loop

      ;

      drop table T1, T2;

       

       

       

      ;