Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Joining two tables based on date-time attributs

data1maths

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.

Find more posts tagged with

AI Studio

Accepted answers

Telcontar120

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.

All comments

lionelderkrikor

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

SGolbert

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

Telcontar120