topic Load data from DB when table is created in QlikView

Load data from DB when table is created

Sat, 12 Nov 2016 13:41:19 GMT

I have an app that is pulling data from a regular SQL database. The DB is structured in such a way that it creates fact tables for every month of the year:

Order_2015_Jan

Order_2015_Feb

Order_2015_Mar

Order_2015_May

Sometimes they do not always run sequential and miss a month. I need to load each of these tables once they are created so the app can report on those months. I can obviously open the app each month and create a LK_Key and load the new table but I need to automate this process. Any idea's?

Many Thanks

Nick

Re: Load data from DB when table is created

swuehl — Sat, 12 Nov 2016 14:05:06 GMT

You can query the available tables using

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatements/SQLTables.htm‌

This should allow you to create a FOR EACH ... NEXT loop in your script to iterate over the order tables available.

You can schedule a periodic reload task for this script or (if your have some kind of external trigger that may inform you about a new table has been created, you can use an EDX trigger approach to reload your script:

Using EDX in QlikView 11