Each LOAD or SELECT statement generates a table. Normally, QlikView treats the result of each one of these as one logical table. However, there are a couple of exceptions from this rule:
- If two or more statements result in tables with identical field names, the tables are concatenated and treated as one logical table.
- If a LOAD or SELECT statement is preceded by any of the following qualifiers, data is altered or treated differently:
| Qualifier | Description |
|---|---|
| concatenate | This table is concatenated with (added to) another named table or with the last previously created logical table. |
| crosstable | This table is converted from crosstable format to column format. |
| generic | This table is split into several other logical tables. |
| info | This table is loaded not as a logical table, but as an information table containing links to external info such as files, sounds, URLs, etc. |
| intervalmatch | The table (which must contain exactly two columns) is interpreted as numeric intervals, which are associated with discrete numbers in a specified field. |
| join | This table is joined by QlikView with another named table or with the last previously created logical table, over the fields in common. |
| keep | This table is reduced to the fields in common with another named table or with the last previously created logical table. |
| mapping | This table (which must contain exactly two columns) is read as a mapping table, which is never associated with other tables. |
| semantic | This table is loaded not as a logical table, but as a semantic table containing relationships that should not be joined, e.g. predecessor, successor and other references to other objects of the same type. |
When the data has been loaded, the logical tables are associated.
