topic Re: Semantic Load in QlikView

Semantic Load

Anonymous — Fri, 27 Dec 2013 09:24:53 GMT

What is Semantic Load and what are its benefits.........

Re: Semantic Load

Anonymous — Fri, 27 Dec 2013 09:28:56 GMT

Nitin

I have never heard of a Semantic Load , where did you hear this term and can you put it into context ?

Best Regards, Bill

Re: Semantic Load

Gysbert_Wassenaar — Fri, 27 Dec 2013 09:34:38 GMT

This is explained in detail in the Qlikview Reference Manual in section Semantic Links. You can find an example here: Self-referential database objects

Re: Semantic Load

tresB — Fri, 27 Dec 2013 09:37:38 GMT

semantic loads a table

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..

for detailed discussion refer, manual (search for 'semantic links').

Example:

Semantic

Tables containing relations between objects can be loaded through a semantic prefix.

The syntax is:

semantic( loadstatement | selectstatement)

Examples:

Semantic Load * from abc.csv;

Semantic Select Object1, Relation, Object2, InverseRelation from

table1;