Expand my Community achievements bar.

Derived Field in Adobe CJA classifying many items as "No Value"

Avatar

Level 1

I set up a Derived Field to only extract the domain names from User ID. I used the following configuration to set up the field:

SpurthiGu_0-1740716975078.png

 

Although the preview looks fine, when viewing the data in a Freeform Table, I see that lot of User IDs which also have domains in them are getting classified as "No Value". What is the reason for this? Could you please help resolve this issue?

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

Your logic looks good.  I tested this and it worked as expected.  All events under No value for email domain had no email address.

Alternatively, you can try using regex in component substring settings.  Use this expression .+@(.+) and output $1.  That should do the same.  Perhaps that will resolve your issue.

 

EDIT - Does your original dimension have persistence applied?  If so, did you replicate that persistence for your derived field?