Databases Reference
In-Depth Information
The
File Wizard: Script
dialog window is shown in the following screenshot:
Let's leave these options as they are for now, and click on
Finish
. The script will be
generated and added to the
Edit Script
window.
Please note that when reading data from a plain table file, we do not
use a
Select
statement but only a
Load
statement. That is because
the SQL
Select
statement is only used to send the appropriate
command to the ODBC, OLE DB, or some other data connectivity
drivers, and query the database. Since we are only loading a local
file, no driver is being used, and the built-in QlikView extraction
functionality is used to pull data into our document.
We can now reload the script, and the table will be pulled into QlikView and treated
like any other table from any other source, from hereafter.
Save before reloading
The reload operation will execute every script statement, and there
will be times when the script execution will fail for a number of
reasons. Therefore, it's a good practice to hit
Save
before actually
reloading the script. In some cases, when the reload fails, changes
since the last save are lost.
We have now loaded the
Origin Market
table. Take a moment to do the same with
the
Destination Markets
table and include it in our data model. Afterwards, save
and close the QlikView document.