Data Sources - QlikView 11 for Developers - page 76

This will not exclude any records, but you can manipulate it after the script
is created.

We will talk about using advanced Where Clause in Chapter 7 ,
Scripting and Chapter 8 , Data Modeling Best Practices .

The crosstable
QlikView is also able to convert crosstables (a table where there is a column for
each dimension in a range) to traditional tables. For the file we are loading in this
example, we won't need this function, but it's important that you know about it since
this table structure is very common, particularly in budget spreadsheets. An example
of a crosstable is shown here:

Department Jan Feb Mar Apr May Jun

A 160 336 545 152 437 1

B 476 276 560 57 343 476

C 251 591 555 195 341 399

D 96 423 277 564 590 130

These tables, because of their structure, are not appropriate for a QlikView data
model. We will discuss this topic further in Chapter 8 , Data Modeling Best Practices ,
along with other transformation options and hierarchy tables.

The resulting script
For now, let's continue to the next step in the File Wizard . Click on Next from the
File Wizard: Options window, and the File Type: Script dialog will appear.

This window basically lets us take a look at the generated script with the
configurations set in the previous steps. Additionally, we can set a Max Line
Length parameter to make the script easier to read once it is pasted into the
Script Editor , or enable the Load All (*) option, which will generate a script that
indistinctively loads every field in the source table.

If you have previously changed field labels, or excluded some
fields from the load (using the File Wizard: Type window),
you should not use the Load All (*) option, since it will
override those previous settings.