Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Add multiple tables/excel files into QlikView

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.

1 Solution

Accepted Solutions
julian_rodrigue
Valued Contributor

Re: Add multiple tables/excel files into QlikView

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

Regards

5 Replies
julian_rodrigue
Valued Contributor

Re: Add multiple tables/excel files into QlikView

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

Not applicable

Re: Add multiple tables/excel files into QlikView

Hello Julian,

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

Tanya.

julian_rodrigue
Valued Contributor

Re: Add multiple tables/excel files into QlikView

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

Regards

Not applicable

Re: Add multiple tables/excel files into QlikView

Thank you, Julian, I found it.

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

julian_rodrigue
Valued Contributor

Re: Add multiple tables/excel files into QlikView

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