Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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..
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