Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LOAD Number, Date, Group
FROM YourFile
WHERE Number like 'IN*';
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.