I have two arrays sets. I am trying to match closest date (with in one hour) to Col1 of array1 and col2 of array2 that into Col3 in array1, if there is no match Col3 will stay as NA
Finally array1 should look like;
array1
Col1 Col2 Col3
date1 data1 actionx
date2 data2 NA
daten datan actiony
array2
col1 col2
date1+0:10 actionx
daten+0:33 actiony
Thanks
Adam
Bookmarks