https://community.qlik.com/t5/Connectivity-Data-Prep/Ultimo-registro-por-fecha/m-p/1954959#M11055 <P>Buenas tardes quería saber como obtener los últimos dos registros para cada dia, para la carga de scripts. Esta es la tabla que tengo.</P> <P>&nbsp;</P> <TABLE class=" lia-align-center" width="169"> <TBODY> <TR> <TD width="86.7344px" height="25px" class="lia-align-center" style="font-weight: 400;">Materiales</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">Fecha</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12324199</TD> <TD width="81.2656px" height="25px" class="lia-align-left" style="font-weight: 400;">1/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12349090</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390984</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390985</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390986</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12391758</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12403498</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12415203</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12419181</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">1/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12427423</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12457274</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12494595</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12789952</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">11534159</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12076156</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12115855</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12415202</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">1/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12151876</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12153645</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12171508</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12427421</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">10516043</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">11110353</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12947522</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/3/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Muchas Gracias!</P> Wed, 13 Jul 2022 04:14:56 GMT Luis171190 2022-07-13T04:14:56Z https://community.qlik.com/t5/Connectivity-Data-Prep/Ultimo-registro-por-fecha/m-p/1954959#M11055 <P>Buenas tardes quería saber como obtener los últimos dos registros para cada dia, para la carga de scripts. Esta es la tabla que tengo.</P> <P>&nbsp;</P> <TABLE class=" lia-align-center" width="169"> <TBODY> <TR> <TD width="86.7344px" height="25px" class="lia-align-center" style="font-weight: 400;">Materiales</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">Fecha</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12324199</TD> <TD width="81.2656px" height="25px" class="lia-align-left" style="font-weight: 400;">1/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12349090</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390984</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390985</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12390986</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12391758</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12403498</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12415203</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/1/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12419181</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">1/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12427423</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12457274</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12494595</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12789952</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">11534159</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12076156</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12115855</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/2/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12415202</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">1/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12151876</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">2/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12153645</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">3/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12171508</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">4/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12427421</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">5/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">10516043</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">6/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">11110353</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">7/3/2022</TD> </TR> <TR> <TD width="86.7344px" height="25px" style="font-weight: 400;">12947522</TD> <TD width="81.2656px" height="25px" style="font-weight: 400;">8/3/2022</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Muchas Gracias!</P> Wed, 13 Jul 2022 04:14:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Ultimo-registro-por-fecha/m-p/1954959#M11055 Luis171190 2022-07-13T04:14:56Z