Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Merging Two CSV files Based on Two Columns

by clueless newbie (Chaplain)
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

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.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://992482]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (4)
As of 2018-06-18 06:54 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (109 votes). Check out past polls.