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 ?

[Anonymous · Accepted solution]

i want to remove the 1st 2 rows and load name , age and gender as headers

[CELAMBARASAN]

Hi,

Use Header size option.

[MK_QSL]

Go to the EDIT script

Load the file using Table Files

Select the file

Select Lines under Header Size section

Select 2

Labels Embedded Labels

Hope this will help...

[Clever_Anjos]

LOAD name,

     age,

     gender

FROM

Pasta1.xlsx

(ooxml, embedded labels, header is 2 lines, table is Plan1);

[#6]

while  loading data table use lines equal = 2 it will solve ur problem

[Anonymous]

Perfect  thank you very much

[#8]

mark it as answered question

[Anonymous]

how can i do this ? I am sorry but this is my 1st time

[MK_QSL]

You can see Correct Answer and Helpful Answer for every answer given.

Please tick on the right one.