I would like to query the Data extension record - subscriber with phone field contains data and aswell phone field not containing data .

VAR @Rows2,

SET @Rows2 = LOOKUPROWS("dataextensionREcord","subscribe", "true", "Country","US", "Phone", "")
%%=ROWCOUNT(@Rows2) =%%

Result : fail

I tired following :

SET @Rows2 = LOOKUPROWS("dataextensionREcord","subscribe", "true", "Country","US", "Phone", isNull("Phone"))

SET @Rows2 = LOOKUPROWS("dataextensionREcord","subscribe", "true", "Country","US", isNull("Phone"),true)

I don't see anything with NOT-EMPTY or NOT-NULL or any other function to query with for fields which contain/do not contain data. How can this be done ?

Attribution to: Jack85

Possible Suggestion/Solution #1

Unfortunately, you cannot do what you're looking to do, directly. Don't I WISH! I do have a couple of workarounds for you:

Write a query activity to do your segmenting for you into another data extension. Then, do your look ups based on that new DE.

OR

Create your own definition of "null", and make that the default on that field. So, instead of having "null" on a phone field you would have 999-999-9999 or something. Then when you're looking for null fields, you would look up by 999-999-9999.

Hope this helps.

Attribution to: Timothy
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/32340