topic Remove() function in filters in QlikView

Remove() function in filters

Tue, 02 Aug 2011 11:37:52 GMT

Hi,

I am going through a script which loads data from .csv file. Script contains "Remove()" function in the filters and I an unable to comprehend the usage and syntax. Can somebody help me on this?

Code Extract:

Load

.....

FROM

O1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

Remove(Col, Pos(Top, 2)),

Remove(Col, Pos(Top, 4)),

Remove(Col, Pos(Top, 36))

));

Thanks a lot!

rishu

Remove() function in filters

lironbaram — Tue, 02 Aug 2011 12:00:10 GMT

it remove the columns number 2,4,36

Remove() function in filters

Tue, 02 Aug 2011 12:16:16 GMT

Thanks for reply!

Code contains some lines like below. Why it will be required to remove column 7,9 twice and 5 times!! Any idea?

Remove(Col, Pos(Top, 2)),

Remove(Col, Pos(Top, 4)),

Remove(Col, Pos(Top, 7)),

Remove(Col, Pos(Top, 9)),

Remove(Col, Pos(Top, 9))

regards,

rishu

Remove() function in filters

Tue, 02 Aug 2011 13:53:59 GMT

Hi there, I think the remove function uses reference indexes for the column to be removed, for instance, if you have a table containing ten columns, and you remove number 9, then you table will have 9 columns now, and your former column 10 will be column 9 now, so if also want to remove the former column 10, you will also have to add another remove pointing to column 9.

I hope I was clear enough, it is a bit tricky.

Regards

Remove() function in filters

danielrozental — Tue, 02 Aug 2011 14:37:11 GMT

Remove filters are inserted when you use the transformation wizard when reading a file.

I try to avoid them honestly, I find it's way more clear just to remove columns from the load or add where clauses when possible.

Remove() function in filters

Tue, 02 Aug 2011 17:09:29 GMT

Thanks Ivan!

Got it. But really confusing.

Remove() function in filters

Tue, 02 Aug 2011 17:10:48 GMT

Yes.. Should be avoided. Very confusing.

regards,