Datasphere data flow null value in target table

[jeanramon]

I created a data flow to improve data persistence. It goes from Graphical View -> Data Flow (scheduled to run every 20mins) -> Local Table -> Analytic Model.

This works fine but somehow there is a column that does not receive any values (just NULLs). It's a date column. It is mapped correctly. It is labeled as date on both sides. When I data preview in the data flow, the source shows the values for that column but the target just shows NULLs.

Any ideas what could be wrong or where to fix it?

[sravan_aleshwaram]

Hello @jeanramon 

Likely date format/type mismatch in Data Flow
Check Source vs Target datatype (DATE vs TIMESTAMP)
Add conversion function (e.g., TO_DATE() or explicit cast)
Also verify mapping + null handling rule

Thanks,
Sravan

[jeanramon]

Hello Sravan, there is no format mismatch as both sides are labeled as dates. From the graphical view until the local table, the data type stays the same. There are no conversion functions anywhere. Also values are not null in the source so there is no null handling rule involved.