Fetching issue - Excel - Too many lines loaded - Takes time
I am fetching data from an Excel workbook. Each Excel sheet is laoded into a Qlikview table.
All goes smoothly except for one sheet where 13,000,000 lines are fetched even though I only have 80,000 data point. The structure of the sheet is very similar from the other sheets in the same workbook, and in the other cases there is no problem.
Re: Fetching issue - Excel - Too many lines loaded - Takes time
what you could try, if it's possible in your scenario, is load that table beforehand and store it into a qvd. That will not make it faster, but shift the workload, so your actual app will be loaded faster.