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

How to pull data from multiple tables in a single excel sheet

I need to import data from an excel sheet which has multiple tables in a single tab. These tables are separated by spaces. Is there a way to import this data to Qlikview?

Thanks,

Nihar

5 Replies
nirav_bhimani
Not applicable

Re: How to pull data from multiple tables in a single excel sheet

Hi,

Use enable transformation step while loading the excel data, select the filed or rows which you want to delete and click on Delete Marked then pull the single table each time.

See the attachment,

regards,

Nirav Bhimani

Not applicable

Re: How to pull data from multiple tables in a single excel sheet

Hi Nirav,

Thanks a lot for replying! You pointed out a neat and good way to solve my problem.

However, I need to pull my data from an ODBC connection and not an excel sheet. So, I dont get a chance to to use the enable transformation step directly. Any idea how to transform data and perform functions like delete data and do a transpose while using an ODBC connection?

Thanks,

Nihar

Gysbert_Wassenaar
Not applicable

Re: How to pull data from multiple tables in a single excel sheet

Open Excel, select the range of a table and then give it a name in the input box on the top left just above the sheet grid. Do that for all the tables on your sheet. The names of the named ranges are tables you can access via odbc and with the Table Files wizard.


talk is cheap, supply exceeds demand
Not applicable

Re: How to pull data from multiple tables in a single excel sheet

Thanks Gysbert. But we have a requirement where the excel sheet changes every month. You if we use your solution, we would need to manually change the excel sheet once every month..

Not applicable

Re: How to pull data from multiple tables in a single excel sheet

Hello,

If the range of the data is defined dynamicaly you don't have to change everymonth. it is an excel issue. You can cherche at   : How to create a dynamic defined range in an Excel worksheet

How it fix your issue

Kind regards