code to do a sql-equivalent to JOIN() (as implemented in digDB)
 

Hi,

First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.

The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/

Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?

Thanks!

code to do a sql-equivalent to JOIN() (as implemented in digDB)
 

There is no problem doing a JOIN in Excel in SQL run on sheet ranges.
Look at this NG thread:
http://shorterlink.com/?H5CZPS

RBS

"urlwolf" wrote in message
oups.com...
Hi,

First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.

The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/

Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?

Thanks!

code to do a sql-equivalent to JOIN() (as implemented in digDB)
 

Just out of interest, why not use Access (or SQL Server 2005 Express which
is free and supports Transact SQL) for data manipulation and then export the
results to Excel if you need to analyse them further?

MH

"urlwolf" wrote in message
oups.com...
Hi,

First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.

The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/

Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?

Thanks!