SAP Knowledge Base Article - Public

3477485 - DataFlow : Having Unmapped Columns in Target table causes NULL values during Dataflow run

Symptom

Have created a table and used it in a Data Flow as a target table. Not all columns are mapped with the source table and the expectation is to add data manually for the unmapped column. Every time when the Dataflow is run the unmapped column gets filled with NULL values and the manually entered value gets replaced with NULL for the unmapped column. 

Environment

SAP Datasphere

Reproducing the Issue

  1. Create a dataflow with a target table with one added column that does not match the source table
  2. Run the dataflow so the target table gets populated with values
  3. Add values for the unmapped column using data editor
  4. Run the dataflow and the manually added value gets replaced with NULL

Resolution

This is a documented restriction in Datasphere. New runs of the dataflow will insert null values to unmapped columns. This is documented under Process Source/Target Changes in the Data Flow Editor.  

See Also

Creating a Data Flow

Keywords

Dataflow, NULL, unmapped column, datasphere , KBA , DS-DI-DF , Data Flows , Problem

Product

SAP Datasphere 1.0