Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Reload the most recent table on db

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.

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.

But maybe i need to recheck previous period after rework on db, can you help me?

Thanks

1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III

QlikView has a SQLTABLES; statement that allows you to load all table names from a database. From the resulting data set, you can deduce the table called table_nn with the highest value nn.

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.

Best,

Peter