Forum Discussion

prathyoo's avatar
prathyoo
Icon for Advocate II rankAdvocate II
6 years ago

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...
Need Help
prathyoo's avatar
prathyoo
Icon for Advocate II rankAdvocate II
5 years ago

Greg_Deckler   Thanks for taking notice of this issue. Would you be able to help us out. We have separately raised this with support and are waiting to see how that proceeds.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, did you receive any reply from support on this behaviour?

  • prathyoo's avatar
    prathyoo
    Icon for Advocate II rankAdvocate II
    5 years ago

    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.