Since you have the data as well, why not provide it (a small part at least with which your issue is reproducible)? Isn't it much easier than to ask everyone who's willing to help to create a data and test your code?
Arun On Monday, June 17, 2013 at 8:54 AM, Ivan Alves wrote: > Dear all, > > I am not sure I understand the syntax for merging data.tables. I have keyed > the two 'satelite' tables from which I want to match information to the main > table 'links' > > g_ctpty <- gultimate[,list(ctpty_head,ctpty_cty)] > setkey(g_ctpty,ctpty_head) > g_iss <- gultimate[,list(iss_head,iss_cty)] > setkey(g_iss,iss_head) > > Why are the two below not equivalent? > > This works: > > data = merge( > merge(links, g_ctpty, all.x = TRUE, by = "ctpty_head"), > g_iss, > all.x = TRUE, by = "iss_head" > ), > > And this does not: > > data = g_iss[g_ctpty[links]], > > Any guidance would be appreciated. > Kind regards, > Ivan > _______________________________________________ > datatable-help mailing list > [email protected] > (mailto:[email protected]) > https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help > >
_______________________________________________ datatable-help mailing list [email protected] https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
