Options

Joining two tables based on date-time attributs

data1mathsdata1maths Member Posts: 27 Contributor I
edited November 2018 in Help

Hello eveyone, 

Does anybody knows how to join two tables based on a date-time atributs from each, but those attribut are not equal.

Here is the frst date-time attribut from the 1st dataset:

I need to join 2 excel files

the 1st one contine this column:

<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">09</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">10</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">11</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">12</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">13</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">14</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">15</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">16</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">17</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">18</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">19</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">20</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">21</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">22</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">23</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>

 

and the second one is like this:

<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">00</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">01</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">02</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">03</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">04</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">05</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">06</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">10</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">20</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">30</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">40</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">07</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">50</SPAN>
<SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">01</SPAN><SPAN class="pun">/</SPAN><SPAN class="lit">2016</SPAN> <SPAN class="lit">08</SPAN><SPAN class="pun">:</SPAN><SPAN class="lit">00 and so one....</SPAN>

 and i need to do the join based on the nearest value between these date attributs.

I really need your help.

Thank you so much.

Best Answer

  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Solution Accepted

    Another option would be to extract the minute number (using Date to Numerical) and then round to whatever intervals you want using mod arithmetic and rounding inside Generate Attributes.  Then you should be able to create a new field that is the date plus the rounded time interval and use that to Join in RapidMiner.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts

Answers

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @data1maths,

     

    I have difficulties to understand : The 2 date attributes you presented are equal.......

    In this case, you have just to use the Join operator....

     

    If it is not the case, can you describe exactly your dataset(s) ans what you want to obtain ?

     

    Regards,

     

    Lionel

  • Options
    SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 Unicorn

    Hi,

     

    From the documentation, I take that the Join operator only supports equi-joins (which represent 99% of the cases). If you have the tables in a database, your best option is to perform the joins there (SQL statement).

     

    If you are familiar with R, the library data.table support non-equi joins, so you have the option of using the Execute R operator as well.

     

    I hope it helps.

     

    Regards,

    Sebastian

Sign In or Register to comment.