topic Re: Add multiple tables/excel files into QlikView in QlikView

Add multiple tables/excel files into QlikView

Wed, 17 Apr 2013 16:03:02 GMT

Hello,

I am new to QlikView and I am using personal edition, version 11.

I have Excel files and would like to use them as tables in QlikView.

I can only add one table, and can't find an option for adding more.

Any ideas how I can do this?

Thank you,

Tanya.

Re: Add multiple tables/excel files into QlikView

julian_rodriguez — Wed, 17 Apr 2013 16:37:16 GMT

Hello Tanya,

You can add as many Excel (and others) files as you need.

Just follow the File Wizard after pressing the "Table Files..." button, on the Script Editor. It will generate a script code for loading each Excel file (or others) that you need.

Let me know if it's useful for you

Regards,

Julian

Re: Add multiple tables/excel files into QlikView

Wed, 17 Apr 2013 16:45:44 GMT

Hello Julian,

Thanks for your reply. Where do i find Script Editor?

Tanya.

Re: Add multiple tables/excel files into QlikView

julian_rodriguez — Wed, 17 Apr 2013 16:47:41 GMT

Go to File-> Edit Script.... or just press Control+E

Regards

Re: Add multiple tables/excel files into QlikView

Wed, 17 Apr 2013 16:56:35 GMT

Thank you, Julian, I found it.

Sorry for replying three times to your first post, don't know how it happened...

Re: Add multiple tables/excel files into QlikView

julian_rodriguez — Wed, 17 Apr 2013 16:58:21 GMT

You are welcome... Good luck with your Qlikview's experience!