Displaying 1 result from an estimated 1 matches for "joinstr".
Did you mean:
noinstr
2018 Feb 01
2
Data Table Merge Help
...???? Modified Name ?2016-01-01 ?5
Tracy????? Payables????? ?2015-01-01 ?34
Tom??????? Postal??????? ?2015-01-01 ?87
I was able to get this working by using the sqldf library, but it runs for a very long time in my actual dataset and I'd like to use data.table if at all possible.
library(sqldf)
joinString <- "SELECT A.PayeeName, B.Descr, A.PaymentDT, A.Amount
?????? ?????FROM dtDistributions A, dtDepartments B
??????????? WHERE A.DEPARTMENT = B.Department
??????????? AND B.EffDT = (SELECT MAX(ED.EffDT)
??????????????????????????? FROM dtDepartments ED
??????????????????????????? WHERE B.D...