topic Re: Prob during .xls upload in QlikView

Prob during .xls upload

nikhilgarg — Wed, 25 Feb 2015 12:23:21 GMT

Table1:

LOAd distinct @1 as Year,

@23 as [asas],

@45 as [dfdf],

@65 as [hghg]

FROM..... .xls

What does @[values] indicates??

thanks

Re: Prob during .xls upload

MK_QSL — Wed, 25 Feb 2015 12:28:25 GMT

When you are loading any excel file.. you will get File Wizard : Type screen where you need to select Tables, Header Size and Labels...

If you are Selecting None as Labels, you will not get the Table Headers in the original Excel file.

To avoid this problem, select Embedded Labels...

Re: Prob during .xls upload

maxgro — Wed, 25 Feb 2015 12:30:07 GMT

in an xls

field number (column of excel file)

Re: Prob during .xls upload

nikhilgarg — Wed, 25 Feb 2015 12:42:34 GMT

Hey,

THanks. But what do i mean to ask is are they column number in excel file ?

Re: Prob during .xls upload

nikhilgarg — Wed, 25 Feb 2015 12:43:10 GMT

Hey,

THanks. So they are the column number to which we are giving name explicitly . Right ?

Re: Prob during .xls upload

manojkulkarni — Wed, 25 Feb 2015 12:44:23 GMT

In File Wizard Type, if Labels not selected as embedded then your columns from excel will read as

In XLS format, columns will be used with numbers like @1,@2

In XLSX format, columns will be used with numbers like A,B etc

Re: Prob during .xls upload

manojkulkarni — Wed, 25 Feb 2015 12:48:56 GMT

exactly, it is alias name for each column

Re: Prob during .xls upload

nikhilgarg — Wed, 25 Feb 2015 12:50:39 GMT

Hey,Can you give me an example where @[values] as columns are used ?

THanks

Re: Prob during .xls upload

manojkulkarni — Wed, 25 Feb 2015 13:04:17 GMT

Scenario: When you have csv or any data file with no headings but you will be having the information of the schema of data file, in that case you can use alias name to create your QVDs with proper namings.

eg: In your load statment, how did mentioned @1 as year ? either you know the schema in the beginning or might looked at data & renamed.

LOAd distinct @1 as Year,

@23 as [asas],

@45 as [dfdf],