Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: joined records from multiple csv

by Loops (Curate)
on Jul 07, 2015 at 17:11 UTC ( #1133577=note: print w/replies, xml ) Need Help??

in reply to joined records from multiple csv

You're reading and parsing the second file for every record of the first. To speed things up, consider reading that file just once at the start. Put its contents into a hash variable based on the field you wish to join, ie. sap_id. Then as you read each record of the first file, you can very quickly access the data without going back out to the disk file. As an aside, you might want to consider some of the CPAN modules for handling CSV files.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1133577]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (2)
As of 2022-08-19 06:02 GMT
Find Nodes?
    Voting Booth?

    No recent polls found