This is exactly a relational join operation. Check out my response to a recent similar question Combine files, while parsing info.. In the <readmore> section there is an example of how to do this.