Fetching issue - Excel - Too many lines loaded - Takes time

[Anonymous]

Hello

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.

Any idea/suggestion?

The cript loading the data is:

Table:

CrossTable(ID, DATA, 1)

LOAD *

     FROM

[file.xlsx]

(ooxml, embedded labels, table is DATA, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 2))

));

Thank you very much

[marcus_sommer]

Before going further check the hint with concatenation from peter turner

[rajeshvaswani77]

Have an exit script statement just after the load from excel

thanks,

Rajesh Vaswani

[Anonymous]

I created a new sheet, copied the data, and deleted the old sheet. It works fine now. Mighty Excel!

Thanks to all for your suggestions.