As the ISSUERID value is different between the "parent" issuer and the "child" issuer, a AGENTID&':'&ISSUERID key would always be unique - so, how would such a key help in assigning to the child issuer the same values that have already been assigned to the parent issuer?
Using the above dataset as an example, the desired result is this:
In this case here's what you could do (assuming that AGENTID exists in the child issuers QVD):
- LOAD your parents issuer QVD without the ISSUERID Field (Table1)
- LEFT JOIN LOAD your child issuers QVD to Table1
> Now you should have your child records populated
- CONCATENATE LOAD the parents issuers QVD to Table1
Would that work for you?