Hello, I have one basic table and I made application for it. How I add new table in script? To automated add table with opening application. I shall add each day new one to old. I know, that is something like incremental load.
Condition - all tables are same, only values inside new tables are different and name of new table is different (part of name is date).
I have table with name: Basictable second day Newtable01
third day Newtable02
fourth day Newtable03
and I need join newtable each day to basic table. But still I need old data from tables that were inside before.
If the data resides in a database other than a simple log file, the append approach will not work. However, the problem can still be solved with a minimum amount of extra work. The following conditions apply:
The data source can be any database.
Qlik Sense loads records inserted in the database after the last script execution.
A ModificationTime field (or similar) is required for Qlik Sense to recognize which records are new.
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;
STORE QV_Table INTO File.QVD;
The hash signs in the SQL WHERE clause define the beginning and end of a date. Check your database manual for the correct date syntax for your database.
But still Im not sure how write it in script. My english isnt best for understand wholle text.