Account Correlation When Value is Not Null

[mgauvreau1]

Hi,

We are correlating accounts based on their email. We have noticed users with no email are getting their account correlated to a test account with has a NULL email value. How can we update the account correlation rule to not correlate accounts with NULL values. If they don't have an email address in their account, it should not be correlate to a user profile.

Thanks,
Mariella

[rushikeshvartak]

• What is your current account correlation rule?
• and share logs 

[mgauvreau1]

When CP7 is null, the account is getting correlated to a user with a null email address. We do not want this to happen. We do not want the account to correlate if it has a null CP7. No logs.

[rushikeshvartak · Accepted solution]

CASE WHEN users.customproperty7 IS NULL OR TRIM(users.customproperty7) = '' THEN 'abcd' ELSE users.customproperty7 END =accounts.name

[NM]

Hi @rushikeshvartak , will it correlate again if cp7 gets populated in future run?