How to create a trait of a empty onboarded signal?

Avatar

Avatar
Validate 1
Level 2
fernando_alfaro
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Engage 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
fernando_alfaro
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Engage 1
Boost 3
Boost 1
Affirm 1
View profile
fernando_alfaro
Level 2

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
Validate 1
Level 2
fernando_alfaro
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Engage 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
fernando_alfaro
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Engage 1
Boost 3
Boost 1
Affirm 1
View profile
fernando_alfaro
Level 2

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
Validate 1
Employee
garrettchung
Employee

Likes

7 likes

Total Posts

15 posts

Correct reply

7 solutions
Top badges earned
Validate 1
Give Back
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Employee
garrettchung
Employee

Likes

7 likes

Total Posts

15 posts

Correct reply

7 solutions
Top badges earned
Validate 1
Give Back
Boost 5
Boost 3
Boost 1
View profile
garrettchung
Employee

25-03-2018

Try to use ... matchesregex "^$"

and let us know how you go.