Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
waht is logical table in qlikview?
It is just another table.
It is called logical in Qlik primarily because of the following:
Basically, the data models in Qlik expect all tables to be joined using some relation. Data islands cause performance issues and are not suggested. The word "logical" is used due to the relations in the data model.
Hi,
you can also read this:
Good luck
hi it is a straightforward topic in QlikView .
Logical Tables in QlikView Help guide it is avilable.
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:
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.
Hi,
Mapping table stores data logically, it won't appear in data model after script execution it will Remove from the data model . so, we can call Mapping table as Logical table.
Regards
Anji