topic Re: removing rows in QlikView

removing rows

carlos13 — Thu, 14 Feb 2013 10:57:09 GMT

How removing rows starting with PE a field in the load?

Gysbert_Wassenaar — Thu, 14 Feb 2013 11:04:25 GMT

By not loading them in the first place:

Data:

Load * from ...somesource...

where not wildmatch(MyField,'PE*');

Thu, 14 Feb 2013 11:27:52 GMT

There are several ways to accomplish this filter, besides the wildmatch mentioned above, can also use the keyword LIKE.

Ex.:

WHERE YOUR_FIELD LIKE 'PE*'

OR NEGATIVE EXPRESSION

WHERE NOT (YOUR_FIELD LIKE 'PE*')

manideep78 — Thu, 14 Feb 2013 11:53:24 GMT

LOAD * from DataSource

..................

.......................

where NOT(Field_Name LIKE 'PE*');

carlos13 — Thu, 14 Feb 2013 14:17:25 GMT

thank you