Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Delete lines which begin with "Sum"

Hello !

I have an excel file and I want to delete every lines which begin by "Sum". How can I do that ?

Thank you =)

Annie

2 Replies
danielrozental
Honored Contributor II

Delete lines which begin with "Sum"

Look into the string functions part of the help, there are several you can use.

Something like

where index(field,'Sum') <> 1

MVP
MVP

Delete lines which begin with "Sum"

Hi Annie,

you might use the load filter in the script.

It probably looks like:

filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Sum')))

)

(i.e. snippet from

LOAD *

FROM

[Data.xlsx]

(ooxml, embedded labels, table is Quota, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Sum')))

));

If you use the table wizard in the script editor, there is a dialog for transformation steps, use conditional delete and set your requirements.

Stefan

Community Browser