topic Error Loading Table in QlikView

Error Loading Table

Thu, 17 Oct 2013 03:16:54 GMT

Hello Everyone,
I got an error when loading tables from my exel file. The error is "Cannot locate table in BIFF file.."

I export the Budget.xls file from a oracle discoverer tool to my C:\Cars\. Strangely the error is gone when i manually save the budget.xls file once it is exported in my PC.Very puzzling. PLease kindly advise. Thanks!

Below is my script:

Load A,

B,
C,

FROM

(biff. embedded labels, table is Headline$);

Load A,

B,
X,,

FROM

(biff. embedded labels, table is Trades$);

Re: Error Loading Table

jagan — Thu, 17 Oct 2013 05:21:44 GMT

Hi,

Can you attach the excel file you are using, or else try generating the script again by using selecting Table Files button.

I think biff is causing the issue, did you changed from xlsx to xls?

Regards,

Jagan.

Re: Error Loading Table

Thu, 17 Oct 2013 05:29:54 GMT

Hi Mohan,

It seems like Qliview load is unable to locate the 2 tables I have in the exel file.

No, I didn’t change from xlsx to xls. What I did was export from Oracle to Exel file, with those 2 tables.

Any suggestions how to fix this please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Find out more about Platts Oil Methodology Explained Sessions<http://marketing2012.platts.com/content/OLGL2013OM_MethodologyTraining?mvr=eventlisting> in Houston, Singapore and London, or visit the On Demand Session<http://www.plattsmethodology.com/>