2 Replies Latest reply: Jun 6, 2015 1:43 PM by Massimo Grossi RSS

    Drop Field if Match?

    Jason Liau

      Hi,

       

      I have two tables and the Key is C-ID. I haven't loaded in O-ID in table 1 yet but I want to make the connection between Table 1 and Table 2 with rows that have O-ID and drop the C-ID for those rows:

       

      Table 1:

      C-IDL-IDO-ID
      1X
      2Y222
      3Z

       

      Table 2:

      C-IDO-ID2
      1111
      2222

       

      How do I properly do that in the load script?

      if([O-ID] = [O-ID2], DROP FIELD [C-ID])

       

      Thanks!

      Jason