difference between explicit and none

[manoranjan_d]

Hi please explain the difference between explicit and one when we load the table files.

[Clever_Anjos]

Would you mind elaborating a bit more your question?

Maybe posting an example

[maxgro]

do you mean explicit labels? no labels?

[manoranjan_d]

yes

[manoranjan_d]

when we want to import the excel we will always give  embedded, so i found that other options are there such that none and explicit. so when i used that two i cant see the difference between its  performing same activity.

[Digvijay_Singh]

Explicit was provided to handle specific needs of dif files(data interchange format) where a  separate header section with explicit field names is sometimes used,  In such a case, explicit labels should be used.  If nothing is specified, embedded labels is assumed, also for dif files.

[maxgro]

copied from QlikView help

Labels is a file specifier for the Load statement that defines where in a file the field names can be found.

The possible alternatives are:

embedded labels

explicit labels

no labels

The field names can be found in different places of the file. If the first record contains the field names, embedded labels should be used. If there are no field names to be found, no labels should be used. In dif files, a separate header section with explicit field names is sometimes used. In such a case, explicit labels should be used. If nothing is specified, embedded labels is assumed, also for dif files.

Examples:

LOAD * FROM a.txt (unicode, txt, delimiter is ',' , embedded labels)

LOAD * FROM a.txt LOAD * FROM a.txt (unicode, txt, delimiter is ',' , embedded labels)