topic Re: load excel with multiple table on one tab in QlikView

load excel with multiple table on one tab

yelin_nyu — Wed, 17 Dec 2014 20:36:22 GMT

anyone has good suggestion to load excel where the same column contains multiple fields? they have multiple tables different purpose but

how do I tell the load script to stop loading rows below certain point? I could do first 50, but then the number of rows where the next table begins changes from time to time. i don't want to open the file and look at each.

thanks.

Re: load excel with multiple table on one tab

jpapador — Wed, 17 Dec 2014 21:10:39 GMT

I am pretty sure this is impossible in the scripting. You would have to open the excel and cut and paste the second table onto it's own tab within the workbook.

Unless there is a way in the data to distinguish what table is which, you could make a where clause to only load those lines.

Re: load excel with multiple table on one tab

yelin_nyu — Mon, 05 Jan 2015 23:34:55 GMT

cut and paste in excel would defeat the purpose of automation. I figured a way to find where each 'table' begin in excel, but now I need to know how to load only rows specified. for first table and last table, it's easy, just do first ## load * from table and bottom ## load * from table. what do I do with rows in the middle? I know where the rows start and end, how do I just load row 25 to row 55 say i have 100 rows in total?

thanks

Re: load excel with multiple table on one tab

Tue, 06 Jan 2015 00:35:42 GMT

Have you the ability to specify only including rows that contain certain pieces of information? perhaps a where clause to limit the data included in each table?

otherwise, it might be feasible to add a rowno() to the script, and limit the inclusion based on that.