How to create a trait of a empty onboarded signal?

[fernando_alfaro]

Hello

My offline data sometimes delivers value pairs like this:

"MANUFACTURER_CODE"=""

which means I need to create a trait for those that had no value.

If I use regex like "MANUFACTURER_CODE"  matchesregex  ".*" will give me all that have ANY value and then in the segment I can use is in an AND NOT rule.  I would like to have a trait for the NULL or EMPTY value instead

Is this possible?

Thank you

[garrettchung]

Try to use ... matchesregex "^$"

and let us know how you go.

[fernando_alfaro · Accepted solution]

The trait is populating so it seems to work.

I added something else though:

manufacturer_code

matchesregex

"^\s+$|^$"

Thank you