Forum Discussion
Dataflow and Dataset treating null differently
We have a master dataset that was configured to connect to an Oracle database. Nearly 30 odd reports have been built on this dataset (which has around 20 tables - dimensions and facts) using live co...
Hi, did you receive any reply from support on this behaviour?
Yes, but not a favorable one. The ticket was escalated to the product team. PG team said that dataflow tables are stored in csv files and as such have no difference conceptually between empty and null. Null and empty values from source are both saved as empty values. They have suggested that I need to add a step to modify null values from the source to "null" strings.
That means I would need to do this for every table that has a text column where there is a potential that the column could have blank values for some of the records.