Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

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.


Log In?

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2015-11-30 04:03 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (757 votes), past polls