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: 
Anonymous
Not applicable

Documentation about remove() function

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.

5 Replies
petter
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Not applicable
Author

Thank you.

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

What a pity !

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yeah, it is a pity...