Showing results for 
Search instead for 
Did you mean: 

Transformation mapping - unmapped fields set to blank

Former Member
0 Kudos

We are 2004s BI 70 SP 10. When we used a transformation for updating only some fields in a ODS, the load updated unmapped fields to blank values. The datasource is a flatfile. The purpose is to update some fields from file leaving other fields untouched.

Any input on this would be appreciated.


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


What do you mean by blank values... you mean to say Initial Values i.e. space, 0.00 etc? If you said some of fields set to "No Tramsformation" system will take initial value of the Field. We can't avaoid it.

if Unmapped fields contains any Data, that data should be reatined for those unmapped fields. If it is not working as per that... Please look into the SAP Note : <a href="">Note 1024816 - DataStore data fields are overwritten</a>

Mapping to Initial Value or existing Data for that Key shouldn't be a problem.

all the best.


Nagesh Ganisetti.

  • Assign points if it helps.