removing rows

[carlos13]

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

[Gysbert_Wassenaar]

By not loading them in the first place:

Data:

Load * from ...somesource...

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

[#3 · Accepted solution]

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]

LOAD * from DataSource

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

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

where NOT(Field_Name LIKE 'PE*');

[carlos13]

thank you