topic get the Latest records from the table based on the multiple fields in App Development https://community.qlik.com/t5/App-Development/get-the-Latest-records-from-the-table-based-on-the-multiple/m-p/1704782#M54034 <P>Dear All,</P><P>I have one scenario where I need to get the latest records from the tables bases on the following columns.</P><P>first need to check for the latest records by checking the maximum of time_stamp, created_at, updated_at against each app_id. so here is the exception we do have some records with duplicated time_stamp, crated_at and updated_at so in that case, we need to take the maximum id for lasted records.&nbsp; &nbsp;</P><TABLE width="734px"><TBODY><TR><TD width="238.667px">app_id</TD><TD width="174.667px">time_stamp</TD><TD width="108.667px">created_at</TD><TD width="108.667px">updated_at</TD><TD width="50.6667px">id</TD><TD width="52px">status</TD></TR><TR><TD width="238.667px"><STRONG>A001931002440</STRONG></TD><TD width="174.667px"><STRONG>2020-05-15 12:12:05.726007</STRONG></TD><TD width="108.667px"><STRONG>27-12-2019 13:46</STRONG></TD><TD width="108.667px"><STRONG>27-12-2019 13:46</STRONG></TD><TD width="50.6667px"><STRONG>2464</STRONG></TD><TD width="52px"><STRONG>10</STRONG></TD></TR><TR><TD width="238.667px">A001931002440</TD><TD width="174.667px">2020-05-15 12:12:06.253003</TD><TD width="108.667px">11-12-2019 03:20</TD><TD width="108.667px">11-12-2019 03:20</TD><TD width="50.6667px">745</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px">A001993002815</TD><TD width="174.667px">2020-05-15 12:12:05.725006</TD><TD width="108.667px">24-12-2019 11:49</TD><TD width="108.667px">24-12-2019 11:49</TD><TD width="50.6667px">2025</TD><TD width="52px">10</TD></TR><TR><TD width="238.667px">A001993002815</TD><TD width="174.667px">2020-05-15 12:12:06.257008</TD><TD width="108.667px">16-12-2019 14:56</TD><TD width="108.667px">16-12-2019 14:56</TD><TD width="50.6667px">1091</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-19 13:14:03.518848</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">10</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 04:39:50.735021</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">15</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 04:39:52.687678</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">20</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.268946</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">30</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.560618</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">40</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.585107</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">50</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.750316</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">50</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.761145</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">60</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.770877</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">70</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:01:45.182556</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">80</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:04:00.363672</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">100</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:12:41.057400</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px"><STRONG>f34a051e-8c32-4ac2-8635-6dcf0af127fc</STRONG></TD><TD width="174.667px"><STRONG>2020-05-20 07:12:47.590471</STRONG></TD><TD width="108.667px"><STRONG>19-05-2020 13:14</STRONG></TD><TD width="108.667px"><STRONG>19-05-2020 13:14</STRONG></TD><TD width="50.6667px"><STRONG>25597</STRONG></TD><TD width="52px"><STRONG>1000</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the output is highlighted in bold in the above table&nbsp;</P><P>any help is highly applicable&nbsp;</P><P>Thanks,</P><P>BK</P> Sat, 16 Nov 2024 18:35:47 GMT bhaskar_sm 2024-11-16T18:35:47Z get the Latest records from the table based on the multiple fields https://community.qlik.com/t5/App-Development/get-the-Latest-records-from-the-table-based-on-the-multiple/m-p/1704782#M54034 <P>Dear All,</P><P>I have one scenario where I need to get the latest records from the tables bases on the following columns.</P><P>first need to check for the latest records by checking the maximum of time_stamp, created_at, updated_at against each app_id. so here is the exception we do have some records with duplicated time_stamp, crated_at and updated_at so in that case, we need to take the maximum id for lasted records.&nbsp; &nbsp;</P><TABLE width="734px"><TBODY><TR><TD width="238.667px">app_id</TD><TD width="174.667px">time_stamp</TD><TD width="108.667px">created_at</TD><TD width="108.667px">updated_at</TD><TD width="50.6667px">id</TD><TD width="52px">status</TD></TR><TR><TD width="238.667px"><STRONG>A001931002440</STRONG></TD><TD width="174.667px"><STRONG>2020-05-15 12:12:05.726007</STRONG></TD><TD width="108.667px"><STRONG>27-12-2019 13:46</STRONG></TD><TD width="108.667px"><STRONG>27-12-2019 13:46</STRONG></TD><TD width="50.6667px"><STRONG>2464</STRONG></TD><TD width="52px"><STRONG>10</STRONG></TD></TR><TR><TD width="238.667px">A001931002440</TD><TD width="174.667px">2020-05-15 12:12:06.253003</TD><TD width="108.667px">11-12-2019 03:20</TD><TD width="108.667px">11-12-2019 03:20</TD><TD width="50.6667px">745</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px">A001993002815</TD><TD width="174.667px">2020-05-15 12:12:05.725006</TD><TD width="108.667px">24-12-2019 11:49</TD><TD width="108.667px">24-12-2019 11:49</TD><TD width="50.6667px">2025</TD><TD width="52px">10</TD></TR><TR><TD width="238.667px">A001993002815</TD><TD width="174.667px">2020-05-15 12:12:06.257008</TD><TD width="108.667px">16-12-2019 14:56</TD><TD width="108.667px">16-12-2019 14:56</TD><TD width="50.6667px">1091</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-19 13:14:03.518848</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">10</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 04:39:50.735021</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">15</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 04:39:52.687678</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">20</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.268946</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">30</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.560618</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">40</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.585107</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">50</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.750316</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">50</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.761145</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">60</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 06:00:10.770877</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">70</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:01:45.182556</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">80</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:04:00.363672</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">100</TD></TR><TR><TD width="238.667px">f34a051e-8c32-4ac2-8635-6dcf0af127fc</TD><TD width="174.667px">2020-05-20 07:12:41.057400</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="108.667px">19-05-2020 13:14</TD><TD width="50.6667px">25597</TD><TD width="52px">1000</TD></TR><TR><TD width="238.667px"><STRONG>f34a051e-8c32-4ac2-8635-6dcf0af127fc</STRONG></TD><TD width="174.667px"><STRONG>2020-05-20 07:12:47.590471</STRONG></TD><TD width="108.667px"><STRONG>19-05-2020 13:14</STRONG></TD><TD width="108.667px"><STRONG>19-05-2020 13:14</STRONG></TD><TD width="50.6667px"><STRONG>25597</STRONG></TD><TD width="52px"><STRONG>1000</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the output is highlighted in bold in the above table&nbsp;</P><P>any help is highly applicable&nbsp;</P><P>Thanks,</P><P>BK</P> Sat, 16 Nov 2024 18:35:47 GMT https://community.qlik.com/t5/App-Development/get-the-Latest-records-from-the-table-based-on-the-multiple/m-p/1704782#M54034 bhaskar_sm 2024-11-16T18:35:47Z