Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist
Partner - Specialist

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
Author

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

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
Author

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
Author

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