topic Re: Loading data from excel in QlikView

Loading data from excel

Thu, 07 May 2015 10:50:48 GMT

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

Re: Loading data from excel

Gysbert_Wassenaar — Thu, 07 May 2015 10:52:31 GMT

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

Re: Loading data from excel

Thu, 07 May 2015 12:06:24 GMT

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

Re: Loading data from excel

Gysbert_Wassenaar — Thu, 07 May 2015 12:08:03 GMT

Yes.

LOAD *, '$(vSheetName)' as SheetName

FROM

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

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

Re: Loading data from excel

neha_sri — Thu, 07 May 2015 12:22:24 GMT

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

Re: Loading data from excel

Thu, 07 May 2015 13:14:54 GMT

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.

Re: Loading data from excel

Gysbert_Wassenaar — Thu, 07 May 2015 13:18:27 GMT

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

Re: Loading data from excel

Fri, 08 May 2015 12:06:11 GMT

Thanks! It worked