Re: [R] Data Table Merge Help

2018-02-01 Thread Jeff Newmiller
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"

Re: [R] Data Table Merge Help

2018-02-01 Thread Bert Gunter
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,

[R] Data Table Merge Help

2018-02-01 Thread Graeve, Nick
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