Loading data from excel

[#1]

Hi All,

When we load data from an excel file like:

LOAD *
FROM
[\..\..\ABC.xls]
(biff, embedded labels, table is [Qlikview$]);

Is it possible to store the table name Qlikview in a field?

Thanks,

Asma

[Gysbert_Wassenaar · Accepted solution]

LOAD *, 'Qlikview' as SheetName
FROM
[\..\..\ABC.xls]
(biff, embedded labels, table is [Qlikview$]);

[#3]

If the sheet name is stored in a variable,

e.g.Let vSheetName='Qlikview',

then is it possible to store the value of this variable in a field. Instead of hardcoding 'Qlikview' as SheetName, is it possible to read the value from the variable vSheetName and store it in the field SheetName

[Gysbert_Wassenaar]

Yes.

LOAD *, '$(vSheetName)' as SheetName

FROM

[\..\..\ABC.xls]

(biff, embedded labels, table is [$(vSheetName)]);

[neha_sri]

Hi Asma,

Yes, you can do so...

Let vSheetName='Qlikview'

LOAD *,

'$(vSheetName)'    as  SheetName

FROM
[\..\..\ABC.xls]
(biff, embedded labels, table is [Qlikview$]);

This should work.

Regards

[#6]

I tried using the code which you mentioned, but it is giving me an error

Cannot locate table in BIFF file.

The table Qlikview is present in the file.

[Gysbert_Wassenaar]

The sheetname of .xls files needs to be appended with a $. If the name of the sheet is Qlikview then the name of the table is Qlikview$.

[#8]

Thanks! It worked