Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Before going further check the hint with concatenation from peter turner
Have an exit script statement just after the load from excel
thanks,
Rajesh Vaswani
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.