topic Re: difference between explicit and none in QlikView

difference between explicit and none

manoranjan_d — Thu, 06 Aug 2015 20:21:34 GMT

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

Re: difference between explicit and none

Clever_Anjos — Thu, 06 Aug 2015 20:25:48 GMT

Would you mind elaborating a bit more your question?

Maybe posting an example

Re: difference between explicit and none

maxgro — Thu, 06 Aug 2015 20:33:20 GMT

do you mean explicit labels? no labels?

Re: difference between explicit and none

manoranjan_d — Thu, 06 Aug 2015 20:35:45 GMT

yes

Re: difference between explicit and none

manoranjan_d — Thu, 06 Aug 2015 20:39:11 GMT

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.

Re: difference between explicit and none

Digvijay_Singh — Thu, 06 Aug 2015 20:48:32 GMT

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.

Re: difference between explicit and none

maxgro — Thu, 06 Aug 2015 21:07:18 GMT

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)