delete lines from excel sheet

[Anonymous]

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 ?

[tresesco]

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.

[#3]

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)

[Clever_Anjos]

Do you want delete lines or not load some lines?

A load stament permits a "where" clause that filters what is beeing loaded

[#5]

will u please explain your question  briefly 

[Anonymous]

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

[Clever_Anjos]

Directory;

LOAD A,

     B,

     C,

     D,

     E,

     F,

     G

FROM

[yourexcelfile.xlsx]

(ooxml, no labels, header is 2 lines, table is [1°]);

[#8]

while loading data this type of transformation is possible

[Anonymous]

i can't understand can you explain more

[Clever_Anjos]

header is 2 lines

instruct QlikView to not load first 2 lines