How to create new field in load script that contains identical info as another?

[#1]

Hi guys,

I'm running into issues pertaining to linking information I need.  Basically, in one of my QVD tables, lets call it QVD-A, I have two different fields that contain similar strings of information.  I need to link both fields to the same field in QVD-B but do not know how to do this.  I feel like the answer is to "clone" and rename the field I'm referencing in QVD-B but I am not sure.

Here's an example:

QVD-A

Fields:

*SalesRepID

*2ndSalesRepID  

I need to link this to...

QVD-B

Field:

*SalesRepID       (this field contains the information for both SalesRepID and 2ndSalesRepID in QVD-A)

SalesRepName

---

So, how to I copy "SalesRepID" from QVD-B & make a new field containing identical information?  I want to achieve this:

QVD-A

Fields:

*SalesRepID

*2ndSalesRepID  

link to

QVD-B

Field:

*SalesRepID

*2ndSalesRepID   (same info as SalesRepID)

SalesRepName

Does that make sense?  Can anyone assist?

[rwunderlich]

LOAD

     *,

     SalesRepID as 2ndSalesRepID

FROM qvdB.qvd (qvd);

-Rob