Derived Field in Adobe CJA classifying many items as "No Value" | Community
Skip to main content
February 28, 2025
Solved

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

  • February 28, 2025
  • 1 reply
  • 464 views

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:

 

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?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Josh Stephens

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?

1 reply

Josh Stephens
Community Advisor
Josh StephensCommunity AdvisorAccepted solution
Community Advisor
March 3, 2025

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?