I rarely use data.table, but I think the vignette for the package discusses
rolling joins. Also, Google popped up [1].
[1] https://www.r-bloggers.com/understanding-data-table-rolling-joins/
--
Sent from my phone. Please excuse my brevity.
On February 1, 2018 9:45:53 AM PST, "Graeve, Nick"
Did you search first? (This is suggested by the posting guide -- below
-- prior to posting).
"merge 2 data.tables in R" brought up what looked like useful stuff,
in particular the merge() function for data tables. If this does not
do what you want, it may help to explain why not.
Alternatively,
Hello
I'm not sure if this is an appropriate use of this mailing list or not, please
let me know if it isn't. I'm struggling to figure out how to merge two data
tables based on max effective date logic compared to when a payment occurred.
My dtDistributions DT is a transactional dataset
3 matches
Mail list logo