topic Re: Re: Unkown file format specifier in QlikView

Unkown file format specifier

Tue, 12 Nov 2013 05:15:16 GMT

Hi guys,

I am loading an excel file and it has two sheets lets suppose A and B. Both has similar structure and i use For Each loop for loading these files. Whenever i use this logic before it works but this time it generates an error which is 'unknown file format specifier'.

Kindly give me solution to solve this problem.I will very thankful to you guys..

Thanks in Advance...

Re: Unkown file format specifier

Anonymous — Tue, 12 Nov 2013 05:21:04 GMT

Is the file path set to a variable? If not that may be the issue.

For reference:

http://community.qlik.com/thread/47437

Re: Unkown file format specifier

Tue, 12 Nov 2013 05:32:41 GMT

Actually when i load sheets individually it works but when i load both sheet in loop it doesn't and generates error.So i think their is nothing issue in path.

Please Help me out....

Re: Unkown file format specifier

Anonymous — Tue, 12 Nov 2013 05:43:51 GMT

I would have to guess your Loop Statement is the cause. Try the below resources to reformat your statement.

QlikView Maven: Loading All of the Files from a Folder

http://community.qlik.com/thread/62449

Re: Unkown file format specifier

kumarnatarajan — Tue, 12 Nov 2013 05:46:29 GMT

Hi Syed,

When try to load multiple sheet you should have MS drive. else you made path problem. else send me your script i will help you

Re: Unkown file format specifier

Tue, 12 Nov 2013 05:52:07 GMT

Kumar i am sending you my qvw file for helping me hope you will do it Thanks..

Re: Unkown file format specifier

Tue, 12 Nov 2013 06:51:18 GMT

Anyone please helping me out...!!

Re: Re: Unkown file format specifier

kumarnatarajan — Tue, 12 Nov 2013 07:06:45 GMT

HI Syed,

PFA simple script.

Else find the below url:

Loading from multiple Excel files and multiple sheets

Re: Unkown file format specifier

kavicsgym — Fri, 13 Feb 2015 21:26:56 GMT

Kumar's solution is GOOD, the issue was with the table name specification during xls load.

Instead this:

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

this one has to be used:

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

Thanks!