On Thu, Mar 29, 2012 at 4:28 AM, Eric Fail wrote:
> Dear R experts,
>
> I've realized that it might not be possible to define a negative SELCET
> statement in a SQL call so now I'm looking for the smoothest way to generate
> a list of what I would like from my large database by first pulling all
Try this:
mapply('[', DBquery, mapply(setdiff, lapply(DBquery, names), lookup))
On Sat, Mar 31, 2012 at 5:50 PM, Eric Fail wrote:
> a working solution to the problem,
>
> a <- DBquery[names(lookup)]
>
> mother.of.lookup <- list()
> for(string in names(a)) {
> a[[string]] <- names(a[[string]])
a working solution to the problem,
a <- DBquery[names(lookup)]
mother.of.lookup <- list()
for(string in names(a)) {
a[[string]] <- names(a[[string]])
mother.of.lookup[[string]] <- setdiff(a[[string]], lookup[[string]])
}
identical(mother.of.lookup, result)
It might not be the most elegan
?setdiff
Sent from my iPad
On Mar 29, 2012, at 4:28, "Eric Fail" wrote:
> Dear R experts,
>
> I've realized that it might not be possible to define a negative SELCET
> statement in a SQL call so now I'm looking for the smoothest way to generate
> a list of what I would like from my large dat
Dear R experts,
I've realized that it might not be possible to define a negative SELCET
statement in a SQL call so now I'm looking for the smoothest way to generate a
list of what I would like from my large database by first pulling all the names
with a query like this "SELECT top 1 * FROM your
5 matches
Mail list logo
