topic Re: Excel tab name is not consistant in QlikView

Excel tab name is not consistant

dsharmaqv — Thu, 12 Jan 2017 10:54:34 GMT

I am using excel file as a source, but the tab name is not consistant every time.

for example

some time it is coming as

FROM
[$(vFile)]
(ooxml, embedded labels, table is [Employees(1)]);

FROM
[$(vFile)]
(ooxml, embedded labels, table is [Employees(2)]);

etc

Can some one assist me to make it dynamic while loading.

enriquem — Thu, 12 Jan 2017 11:02:24 GMT

Hi,

This is for files on a directory, but you can try to do something like this

for each File in filelist('..\yourFileDirectory\Employees*.qvd')

LOAD * From $(File) (qvd);

next File

Maybe, if you can do a tablist.... yo can do something like

for each Tab in tablist(File)

LOAD * From $(File) (ooxml, embedded labels, table is [tablist]);

next File

Regads.

dsharmaqv — Thu, 12 Jan 2017 11:23:35 GMT

thanks for your replay

can I have a sample app for this ..... I dont know if there and tablist() function available in QV.

thanks

enriquem — Thu, 12 Jan 2017 11:38:49 GMT

Try this