1 Reply Latest reply: Feb 8, 2013 7:20 AM by Wojciech Parzyszek RSS

    Assigning a parent-child mapping

    V Butler

      Hi,

       

      I have a pair of identifiers that are linked by an AGENTID:

      AGENTID

      ISSUERID

      555

      1234567

      555

      1234568

       

      ISSUERID 1234567 is the "parent" and ISSUERID 1234568 is the "child". I want to create a new column in my table named PARENT_ISSUERID, and assign the value of 1234567 to the new field, for the "child" row - so, the result would look like this:

      AGENTID

      ISSUERID

      PARENT_ISSUERID

      555

      1234567

      -

      555

      1234568

      1234567

       

      How can I achieve this result in a load script?

       

      I have thousands of pairings like this, so the "parent" and "child" ISSUERID values cannot be hard-coded - I am just using 1234567 and 1234568 as examples.

       

      Many thanks,

       

      VB