Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ...;
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 ...;
Thank you for your help!