overview
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| overview [2015/01/29 23:42] – dmitry | overview [2015/01/31 15:08] – dmitry | ||
|---|---|---|---|
| Line 27: | Line 27: | ||
| ==== Derived tables ==== | ==== Derived tables ==== | ||
| Derived tables is a powerful feature that allows transforming data in a non-linear way. When one table is derived from another (source) table it replicates the final result of the latter. So if the source table changes, the derived table changes automatically. In everything else derived tables is just a regular table and can further be modified using various transformations. | Derived tables is a powerful feature that allows transforming data in a non-linear way. When one table is derived from another (source) table it replicates the final result of the latter. So if the source table changes, the derived table changes automatically. In everything else derived tables is just a regular table and can further be modified using various transformations. | ||
| - | |||
| - | For QlikView users - creating a derived table is the same as loading from resident table. | ||
| Since you can derive any number of tables from a table, and then keep transforming every derived table in its own way, you can create non-linear transformation chains. For instance, you can produce two derived tables from a table, transform each of them in its own way and then append or merge them back into one table. | Since you can derive any number of tables from a table, and then keep transforming every derived table in its own way, you can create non-linear transformation chains. For instance, you can produce two derived tables from a table, transform each of them in its own way and then append or merge them back into one table. | ||
overview.txt · Last modified: 2022/07/22 04:36 by dmitry