Re: One to Many is Too Many?

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?

Comment on Re: One to Many is Too Many?

Replies are listed 'Best First'.
Re^2: One to Many is Too Many? by Roy Johnson (Monsignor) on Apr 22, 2008 at 21:35 UTC
Considering the desired output, there's only one file that needs to be read. Caution: Contents may have been coded under pressure.	[reply]
Re^3: One to Many is Too Many? by apl (Monsignor) on Apr 22, 2008 at 21:49 UTC
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-)	[reply]