Re: 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
[download]

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	[reply]

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

[reply]