Prob during .xls upload

[nikhilgarg]

Table1:

LOAd distinct @1 as Year,

@23 as [asas],

@45 as [dfdf],

@65 as [hghg]

FROM..... .xls

What does @[values] indicates??

thanks

[MK_QSL]

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

[maxgro]

in an xls

field number (column of excel file)

[nikhilgarg]

Hey,

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

[nikhilgarg]

Hey,

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

[manojkulkarni]

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

[manojkulkarni]

exactly, it is alias name for each column

[nikhilgarg]

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

THanks

[manojkulkarni · Accepted solution]

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],