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

A table is created and used as a target in a Data Flow.
Not all target columns are mapped to the source table. The expectation is to manually enter values in the unmapped columns.
However, after each execution of the Data Flow, the unmapped columns are filled with NULL values, and any manually maintained values are overwritten.

SAP Datasphere

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

This behavior is by design. During each execution, the Data Flow writes data into the target table and unmapped columns are populated with NULL values.

This is a documented restriction in SAP Datasphere Process Source/Target Changes in a Data Flow | SAP Help Portal.

• If you leave any target table column unmapped, new runs of the data flow will insert null values into it.

Creating a Data Flow

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