Skip to Content
0
Former Member
Dec 02, 2008 at 12:50 PM

Problem with loading Short Text using Formula in Transformation

28 Views

Gurus,

I'm loading Text only for an InfoObject ZTest1.

The Short Text Field is populated with the following Data

=================

Source | Short Text

Filed |

=================

A | AK

B | BK

C | CK

Null | < Blank>

=================

To acheive the requirement I've written a formula at transformation level which loads the short text using if condition, the else part of last 'if' contains a blank.

Upon loading data in the for this Object, when I query the T- Table I can be able to see only three records A, B, C with short text as against four records. In short, the Nulls are not getting replaced with blanks in the formula.

Could any one help me to sort this.

Regards,

Yaseen

Edited by: Yaseen Ahmed on Dec 2, 2008 1:51 PM