Documentation about remove() function

[Anonymous]

Hi.

I can't find anywhere a documentation on the remove() function that we can use during a LOAD statement, into the files parameters.

i.e. :

LOAD *

FROM [data.xlsx]

(ooxml, embedded labels, table is [Sheet 1], filters(

     Remove(Row, Pos(Top, 1)),

     Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

Is anyone have got some informations about this ?

Thanks.

[el_aprendiz111]

Hi,

https://www.tutorialspoint.com/qlikview/qlikview_tutorial.pdf

[petter]

Hi David,

Unfortunately Qlik never bothered (AFAIK) to document the filters-syntax part of the format-spec. So the only way is to use the dialogbox/wizard when loading from a file and see what is generated and possibly guessing the syntax from the resulting code.

-Petter

[Anonymous]

Thanks for the link;

But, unfortunately, this type of document just present the "file loading wizard", and, by this way, the possibility to filter (remove) some rows.

There's no documention that explain how to use/write directly the remove() function into the script page.

[Anonymous]

Thank you.

I've hoped that the community has already written some posts on this subject.

What a pity !

[Peter_Cammaert]

Yeah, it is a pity...