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]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
