Joining two tables based on date-time attributs

data1maths
data1maths New Altair Community Member
edited November 2024 in Community Q&A

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.

Tagged:

Best Answer

  • Telcontar120
    Telcontar120 New Altair Community Member
    Answer ✓

    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.

Answers

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    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
    SGolbert New Altair Community Member

    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
    Telcontar120 New Altair Community Member
    Answer ✓

    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.

Categories