Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Merging Two CSV files Based on Two Columns

by clueless newbie (Hermit)
on Sep 08, 2012 at 13:58 UTC ( #992482=note: print w/ replies, xml ) Need Help??


in reply to Merging Two CSV files Based on Two Columns

With regards to method 1: Your SQL is at fault for the completed file being empty. It should read (Note the "2")

CREATE TABLE completed AS SELECT final2.username,HCDir2.branch,final2.date_modified FROM HCDir2 INNER JOIN final2 ON final2.username = HCDir2.fullname


Comment on Re: Merging Two CSV files Based on Two Columns
Download Code
Replies are listed 'Best First'.
Re^2: Merging Two CSV files Based on Two Columns
by TheCanadian (Initiate) on Sep 14, 2012 at 14:43 UTC

    Hi: clueless newbie

    Thank you for your reply. This method interested me because I wanted to learn SQL as well; not to mention the slick short code to produce the product. I still cannot get this code to work even after the changes you suggested. Right now I am going to focus on straight PERL or PERL with the addition of Text::CSV or Text::CSV_XS.

    I want to thank you as well for having a keen eye for anomalies in file names and variables. Keep up the good work. Sometimes a simple slip in names like this code causes the code to fail with little message as to the reason for the fail.

    TheCanadian

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2015-07-29 07:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (261 votes), past polls