Who can explain a QV load statement filter?

[michael_klix]

While reverse-engineering an inherited script from another programmer, I hit into the following filter of a load script:

....(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N')))

Can someonte tell me what these two filters do?

Thanks a lot

- keep Qliking -

Michael

[sunny_talwar]

This part of the script is auto generated by QlikView when you load the data using File Wizard and do some transformations. Never tried to understand what they do... but you can see about them here

File Wizard: Transform ‒ QlikView

where is File Wizard : Transform?

[sunny_talwar]

For what I understand

Remove(Row, Pos(Top, 2)), -> Removing top two rows

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N'))) -> Conditionally removing rows for some condition

[marcus_sommer]

Like Sunny I went never deeper in this logic because I do all needed transformations with the "normal" syntax. Nevertheless I think it's probably quite self-explanatory:

Remove(Row, Pos(Top, 2))

will delete the second record and is probably the same like where rowno() <> 2

Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'N'))

will delete the records where the values of the 8 column = 'N' also in etwa:

where Column8 <> 'N' or maybe where not wildmatch(Column8, '*N*') because I'm not really sure about the key-word "contain".

- Marcus