Import excel sheet

[bobbydave]

So I am importing an excel sheet.

Number	Date	Group
IN1234	17/04/2016	X
IN12345	18/04/2016	Y
IN123456	19/04/2016	Z

Total: 3; Created 19/04/2016

Imagine the above is exported from excel including the text Total 3 ......

I don't ever want the text Total .... to appear. Is there a way for Qlikview to remove this so I only have the Number column with IN#'s?

Thanks

[swuehl · Accepted solution]

LOAD Number, Date, Group

FROM YourFile

WHERE Number like 'IN*';

[kkkumar82]

While loading the data from Excel, after selecting the file you have a step "enable transformation" which you will get after selecting next rather than finish, there you can select the necessary data, if you have limited data to select , otherwise you can go with Swuehl method.