topic Re: Reload the most recent table on db in QlikView https://community.qlik.com/t5/QlikView/Reload-the-most-recent-table-on-db/m-p/1058326#M641016 <HTML><HEAD></HEAD><BODY><P>QlikView has a <SPAN style="font-family: 'courier new', courier;">SQLTABLES;</SPAN> statement that allows you to load all table names from a database. From the resulting data set, you can deduce the table called <SPAN style="font-family: 'courier new', courier;">table_<EM>nn</EM></SPAN> with the highest value nn.</P><P></P><P>If all those tables always exist but you need to know which one contains the most recent data, you can use an Incremental Load technique. Search for Incremental Load in the Community. There is a massive amount of information available here.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Fri, 05 Feb 2016 17:47:54 GMT Peter_Cammaert 2016-02-05T17:47:54Z Reload the most recent table on db https://community.qlik.com/t5/QlikView/Reload-the-most-recent-table-on-db/m-p/1058325#M641015 <HTML><HEAD></HEAD><BODY><P>Hi inside my app, i've to load every two-months period a table on db to check differences between two systems, so far customer changed manually the name of the table and realoaded qwv.</P><P>The name is like table_01 (jan-feb), table_02 (march-april), etc, now i want to optimize my reload and keep always the latest table. </P><P>But maybe i need to recheck previous period after rework on db, can you help me? </P><P>Thanks</P></BODY></HTML> Fri, 05 Feb 2016 10:04:37 GMT https://community.qlik.com/t5/QlikView/Reload-the-most-recent-table-on-db/m-p/1058325#M641015 canmarroig 2016-02-05T10:04:37Z Re: Reload the most recent table on db https://community.qlik.com/t5/QlikView/Reload-the-most-recent-table-on-db/m-p/1058326#M641016 <HTML><HEAD></HEAD><BODY><P>QlikView has a <SPAN style="font-family: 'courier new', courier;">SQLTABLES;</SPAN> statement that allows you to load all table names from a database. From the resulting data set, you can deduce the table called <SPAN style="font-family: 'courier new', courier;">table_<EM>nn</EM></SPAN> with the highest value nn.</P><P></P><P>If all those tables always exist but you need to know which one contains the most recent data, you can use an Incremental Load technique. Search for Incremental Load in the Community. There is a massive amount of information available here.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Fri, 05 Feb 2016 17:47:54 GMT https://community.qlik.com/t5/QlikView/Reload-the-most-recent-table-on-db/m-p/1058326#M641016 Peter_Cammaert 2016-02-05T17:47:54Z