topic Re: delete lines from excel sheet in QlikView

delete lines from excel sheet

Anonymous — Tue, 24 Sep 2013 14:51:25 GMT

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 ?

Re: delete lines from excel sheet

tresB — Tue, 24 Sep 2013 15:13:11 GMT

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.

Re: delete lines from excel sheet

Tue, 24 Sep 2013 15:17:58 GMT

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)

Re: delete lines from excel sheet

Clever_Anjos — Tue, 24 Sep 2013 15:25:43 GMT

Do you want delete lines or not load some lines?

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

Re: delete lines from excel sheet

Tue, 24 Sep 2013 15:34:21 GMT

will u please explain your question briefly

Re: delete lines from excel sheet

Anonymous — Mon, 07 Oct 2013 14:02:10 GMT

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

Re: delete lines from excel sheet

Clever_Anjos — Mon, 07 Oct 2013 14:04:10 GMT

Directory;

LOAD A,

FROM

[yourexcelfile.xlsx]

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

Re: delete lines from excel sheet

Mon, 07 Oct 2013 14:05:16 GMT

while loading data this type of transformation is possible

Re: delete lines from excel sheet

Anonymous — Mon, 07 Oct 2013 14:06:59 GMT

i can't understand can you explain more

Re: delete lines from excel sheet

Clever_Anjos — Mon, 07 Oct 2013 14:08:03 GMT

header is 2 lines

instruct QlikView to not load first 2 lines

Re: delete lines from excel sheet

Anonymous — Mon, 07 Oct 2013 14:12:12 GMT

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

Re: Re: delete lines from excel sheet

CELAMBARASAN — Mon, 07 Oct 2013 14:16:25 GMT

Hi,

Use Header size option.

Re: delete lines from excel sheet

MK_QSL — Mon, 07 Oct 2013 14:16:51 GMT

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...

Re: delete lines from excel sheet

Clever_Anjos — Mon, 07 Oct 2013 14:16:59 GMT

LOAD name,

age,

gender

FROM

Pasta1.xlsx

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

Re: delete lines from excel sheet

Mon, 07 Oct 2013 14:17:02 GMT

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

Re: Re: delete lines from excel sheet

Anonymous — Mon, 07 Oct 2013 14:18:08 GMT

Perfect thank you very much

Re: delete lines from excel sheet

Mon, 07 Oct 2013 14:19:30 GMT

mark it as answered question

Re: delete lines from excel sheet

Anonymous — Mon, 07 Oct 2013 14:21:24 GMT

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

Re: delete lines from excel sheet

MK_QSL — Mon, 07 Oct 2013 14:26:08 GMT

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

Please tick on the right one.