Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am trying to find a way to enable me to delete lines from an excel sheet that i load into qlikview .
Any ideas ?
i want to remove the 1st 2 rows and load name , age and gender as headers
while loading excel file, use transformation, see the screen shot:
In the next step, you would find deletion option. Once you decide and delete the rows, the code for deletion would get created in the script which you might refer later on and use accordingly.
One of the ways to do this is to go to your script and open the excel file you want to edit.
If the file wizard opens click on the next button.
In the next tab click on enable tranformation step.
Now within the file wizard you can select the lines you want to delete.
When selected click on delete marked.
(you can even make a conditional statement in case the lines you want to delete aren't always in the same row)
Do you want delete lines or not load some lines?
A load stament permits a "where" clause that filters what is beeing loaded
will u please explain your question briefly
sorry for the late reply
what i am trying to do is to delete the 1st 2 rows from an excel sheet then load the rest of the sheet
Directory;
LOAD A,
B,
C,
D,
E,
F,
G
FROM
[yourexcelfile.xlsx]
(ooxml, no labels, header is 2 lines, table is [1°]);
while loading data this type of transformation is possible
i can't understand can you explain more
header is 2 lines
instruct QlikView to not load first 2 lines