Flag both null and certain values

[Anonymous]

Hi,

I have customers with addresses: some of them have a countrycode, while some of them have "null" countrycode. I want to find, (with an  action-button, Select in Field) the customers, that have vaules 6 or 7 or null. Should I flag them in the script? How can I flag both null-values and certain values?

[swuehl · Accepted solution]

A flag in the script could look like

CountryTable:

LOAD

     Country,

     CountryCode,

     If(len(trim(CountryCode))=0 or match(CountryCode ,6,7),1,0) as CountryCodeFlag,

     ...

FROM ...;

[Anonymous]

Thank you for your help!