Displaying 1 result from an estimated 1 matches for "payeenam".
Did you mean:
payeename
2018 Feb 01
2
Data Table Merge Help
...sure if this problem is considered a range of dates or not. At the bottom of this post is a temporarily solution that is working but it runs for a long time due to the amount of data in my actual source.
Here is some sample data to get started:
library(data.table)
dtDistributions <- data.table(PayeeName = c("Bob", "Tracy", "Tom"),
????????????????????????? Department = factor(c("H229000", "H135000", "H047800")),
????????????????????????? Amount = c(5, 34, 87),
????????????????????????? PaymentDT = as.Date(c("2016-01-01", "...