Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-12-13 01:12 AM

Excel Data

Hi,

I have an excel as the data source which has more than 80k rows. Since the Excel has the constriant as the single sheet can hold only 65535rows . The remaining records are part of the next excel sheet. When i am loading the data from the data from the sheet1. But it should take the data from the sheet2 also. Is there any way i can code to take the data from the sheet 2 as well ...

613 Views
0 Likes
2 Replies
Not applicable
‎2010-12-13 01:15 AM
Author

Hi,

You could try loading them seperately but link them together using a primary key.

Regards,

210 Views
0 Likes
Not applicable
‎2010-12-13 02:47 AM
Author

In response to

Thanks msadrikhcb,

Since the excel is output of some other application.I will not be knowing how many sheets are there with data in the excelsheet. Based on the number of rows the sheets will get changed.

210 Views
0 Likes