One or several QlikView internal tables can be dropped from the data model, and thus from memory, at any time during script execution, by means of a drop table statement.
Syntax:
drop table tablename [, tablename2 ...]
drop tables [ tablename [, tablename2 ...]
Information noteThe forms drop table and drop tables are both accepted.
The following items will be lost as a result of this:
- The actual table(s).
- All fields which are not part of remaining tables.
- Field values in remaining fields, which came exclusively from the dropped table(s).
Examples and results:
| Example | Result |
|---|---|
| drop table Orders, Salesmen, T456a; | This line results in three tables being dropped from memory. |
|
Tab1: Load * Inline [ Customer, Items, UnitPrice Bob, 5, 1.50 ];
Tab2: LOAD Customer, Sum( Items * UnitPrice ) as Sales resident Tab1 group by Customer;
drop table Tab1; |
Once the table Tab2 is created, the table Tab1 is dropped. |
