Designating a Null Value

[Former Member]

Hello,

I have a Bex query where for one characteristic, I would like to set it to be null on certain conditions. For example, if the value in the field begins with the letter 'F', then I would like to replace that field with a null value.

How do I go about doing this?

[Former Member · Accepted solution]

such requirement should be taken careof at the backend in field transformation.

check first letter in field routine and assign NULL accordingly.

Edited by: Omprakash Mishra on Feb 10, 2011 11:31 AM

[Former Member]

It's a characteristic. There are 2 kinds of fields, ones that begin with X and ones that begin with Z. We want to take all the fields that begin with Z, and still show the rest of the information in the row, but leave the field Z### blank.

[Former Member]

So there's no way of accomplishing this in Bex?

Edited by: Sarah Richmond on Feb 10, 2011 5:12 PM

[Former Member]

Blank is different than NULL

Blank = ' ' (a space)

NULL = Special char (No Value)

• A workaround could be Virtual characteristic

Edited by: Jen Yakimoto on Feb 11, 2011 9:02 PM

[Former Member]

So there's no way of accomplishing this in Bex?