joins with different timeframes tables

Community Support
1

Hello,

I still have problems understanding joins:

I have a table EU_W1 with weekly data (open price):

<font face='"courier' new monospace><br class='"Apple-interchange-newline"'>Date | W_Open ----------| -------2010.05.01| 1.328752010.05.08| 1.275742010.05.15| 1.235 2010.05.22| 1.257042010.05.29| 1.226382010.06.05| 1.196032010.06.12| 1.210612010.06.19| 1.238 2010.06.26| 1.236942010.07.03| 1.255852010.07.10| 1.263272010.07.17| 1.2922 2010.07.24| 1.291052010.07.31| 1.304512010.08.07| 1.3277 </font>

<font face='"courier' new monospace><br></font>

<font face='"courier' new monospace>And another table EU_D1 with daily data:</font>

<font face='"courier' new monospace><br></font>

Date &nbsp; &nbsp; &nbsp; Open &nbsp; &nbsp;Low &nbsp; &nbsp; Close &nbsp; Trade EntryLevel
------------------------------<wbr style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>---------------------</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.01 1.32875 1.32875 1.32875</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.02 1.3289  1.32865 1.33121 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.03 1.33113 1.3154  1.31955 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.04 1.31953 1.29615 1.29774 -1    1.31913</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.05 1.29769 1.27886 1.2816  0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.06 1.28163 1.25148 1.2654  0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.07 1.2654  1.25852 1.27524 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.08 1.27574 1.27574 1.27594 1     1.27614</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.09 1.27604 1.275   1.28696 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.10 1.28664 1.27221 1.2737  0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.11 1.27373 1.2616  1.26396 -1    1.27333</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.12 1.26398 1.26054 1.26452 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.13 1.26446 1.25163 1.25319 1     1.26486</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.14 1.25319 1.23492 1.23578 -1    1.25279</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.15 1.235   1.235   1.235   0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.16 1.23475 1.23338 1.23585 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.17 1.23587 1.22339 1.23825 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.18 1.23827 1.21439 1.21448 0     0</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.19 1.21445 1.21438 1.23842 -1    1.21405</span><br style='"color:' rgb font-family: new monospace text-align: white-space: normal><span style='"color:' rgb font-family: new monospace text-align: white-space: normal>2010.05.20 1.23836 1.22954 1.25398 1     1.23876</span></wbr>

How can I add a column to the EU_D1 table holding the weekly open price (W_Open) from EU_W1 table?

Cheers

Francisco

2

does

aj[`Date;EU_D1;EU_W1]

do what you want?

3

Yes!, it does!

Thanks a lot!

Francisco