Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yelin_nyu
Creator
Creator

load excel with multiple table on one tab

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.

3 Replies
jpapador
Partner - Specialist
Partner - Specialist

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.

yelin_nyu
Creator
Creator
Author

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

Not applicable

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.