Re: One to Many is Too Many?

[apl]

Hint: You want a hash keyed on the BugID from BUGS.csv

Given that, which file do you think you'd need to read first?

After you've processed the entire first file, how would you process the second file?

After processing the second file, what would you have to do to complete your processing?

[Roy Johnson]

Considering the desired output, there's only one file that needs to be read.

[apl]

I agree and disagree. You're correct that all necessary information is contained in a single file. However, if I were migrating (as the OP is), I'd want to be able to say "Hey, I found the following Bug_Comments.csv record that does not have an associated Bugs.csv record!".

There may be more information in the first file that will be merged, but was not not being provided for the sake of brevity. In any event, I'm being pedantic. 8-)