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
