User account correlation rule not working

[Murari]

Hi Team,

We have a requirement to correlate a account to the user profile.

I have tried creating the user account correlation rule as(where cp2 is mapped with account email) :

But this rule does not help. Can you please confirm how we can resolve it. 

I have attached the log findings below.

Kindly  advise.

[nimitdave]

@Murari , as per rule screenshot attached , correlation will happen when user email will match with accounts cp2. Can you confirm if the data is as per the rule and accounts status is active. 

Logs also show the same .

[Murari]

Hi @nimitdave ,

As I can see in the user profile email id is blank and CP2 contains a valid email ID.

User Profile-

Account details-

Can you please suggest, If I can correlate Username with CP2 without @xxxx.com.my in advance rule because there is no attributes is available at the target matching to Username.

Thanks.

[This message has been edited by moderator to mask PII info]

[nimitdave]

@Murari , please try below:

users.username=substring_index(accounts.customproperty2,'@',1)

[Murari]

Hi @nimitdave ,

I have tried with Advance config - users.username=substring_index(accounts.customproperty2,'@',1) but it is still not working.

Please find the debug logs below-

Thanks

[Murari]

Hi Team,

Appreciate your guidance on above?

Thanks.

[nimitdave]

@Murari , please run the sql query in the logs from data analyzer and see if any match is coming.