10 Replies Latest reply: Mar 10, 2017 11:56 AM by Sunny Talwar RSS

    Help with script

    omar bensalem

      Hi all, ( stalwar1),

       

      I have 2 tables:

      table1:

      load * Inline [

      dossier

      AU1

      AU2

      TN

      ];

       

      NoConcatenate

       

       

      table2:

      load * Inline [

      dossier

      AU1

      TN

      ];

       

      What I want to do is:

       

      I want to compare fields in both tables, if I find a 'dossier' in table2 that begins with AU (AU1) I have to drop this field from table1.

       

      So the final table would be only table1 (drop table2 once finished)

       

      And table1 should contain : AU2 (not found in table2) and TN.

       

      A help would be appreciated ; thanks,