How to create a trait of a empty onboarded signal?

Avatar

Avatar

fernando_alfaro

Avatar

fernando_alfaro

fernando_alfaro

07-03-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

fernando_alfaro

Avatar

fernando_alfaro

fernando_alfaro

03-04-2018

The trait is populating so it seems to work.

I added something else though:

manufacturer_codematchesregex"^\s+$|^$"

Thank you

Answers (1)

Answers (1)

Avatar

Avatar

garrettchung

Employee

Avatar

garrettchung

Employee

garrettchung
Employee

25-03-2018

Try to use ... matchesregex "^$"

and let us know how you go.