Discussion board where members can get started with QlikView.
I have an excel file and I want to delete every lines which begin by "Sum". How can I do that ?
Thank you =)
Look into the string functions part of the help, there are several you can use.
where index(field,'Sum') <> 1
you might use the load filter in the script.
It probably looks like:
Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Sum')))
(i.e. snippet from
(ooxml, embedded labels, table is Quota, filters(
If you use the table wizard in the script editor, there is a dialog for transformation steps, use conditional delete and set your requirements.