Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
LOAD
*,
SalesRepID as 2ndSalesRepID
FROM qvdB.qvd (qvd);
-Rob