Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
antoinelaviron
Partner - Contributor III
Partner - Contributor III

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

View solution in original post

5 Replies
tresesco
MVP
MVP

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
Author

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
Author

plz attach your excel file

antoinelaviron
Partner - Contributor III
Partner - Contributor III

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

tresesco
MVP
MVP

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.