Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
canmarroig
Contributor

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

Tags (2)
1 Reply

Re: Reload the most recent table on db

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

Community Browser