Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Excel Load remove row

Hi

I have an excel file whiche has some values at the and which are not needed. I know i can remove the row by loading it with "Remove(Row, Pos(Top, 35)),".

But is it also posible to say i want to remove all starting by the row with the value "Signature" (unknowk position). That he finds the correct row and then removes everything after this row?

1 Solution

Accepted Solutions
Partner
Partner

Re: Excel Load remove row

Hi

When loading your Excel file, use the wizard of Qlikview.

In the second step, tab Garbage, click on Conditional delete.

There you can add filters and you will have a staement like this (in this case we filter on the first column)

Remove(Row, RowCnd(CellValue,1,StrCnd(equal,'Signature')))

Best

Antoine

5 Replies
MVP
MVP

Re: Excel Load remove row

Say, you have the first column col1 , then you can try something like this:

Load

          Col1, Col2

From <your excel file path> Where Col1<>'Signature';

Not applicable

Re: Excel Load remove row

The file is like that

col1               col2

1                    550

2                    298

3                    510

4                    160

5                    560


Signatur    

--------

Timestamp

BlaBla

moreBlabla

now i would like to find the place where Signatur is because i would like to remove or do not load it after that beacuse it shouldnt be in the qv. The problem is, its alot after Signatur and every table has some other words in blabla so its also not easy to load then from multiple tables   

Not applicable

Re: Excel Load remove row

plz attach your excel file

Partner
Partner

Re: Excel Load remove row

Hi

When loading your Excel file, use the wizard of Qlikview.

In the second step, tab Garbage, click on Conditional delete.

There you can add filters and you will have a staement like this (in this case we filter on the first column)

Remove(Row, RowCnd(CellValue,1,StrCnd(equal,'Signature')))

Best

Antoine

MVP
MVP

Re: Excel Load remove row

In that case, try something like this:

Load

          RecNo() as Rec

From .... Where Col1='Signature';

Let vVariable=Peek('Rec',0);  // edit

FinalTable:

Load Col1, Col2

from .... Where  Col1 RecNo()< $(vVariable);

Sorry, a bit of change.