define word "Null" to be actual NULL
Moderators: chulett, rschirm, roy
define word "Null" to be actual NULL
Is it possible to define this in the definition file or do I have to just do it in a transformer stage. I noticed there is a option in the definition dialog called "null field value" byt setting this to "Null" does not change anything.
Found the problem:
I could set "Null field value" = "Null" as a global default in the definition file, but it was not picking it up because for some reason ALL of the fields had the "Null field value" set to "" at the row level (i.e. "Edit Row")
So Now I have to go in and edit each row (50 odd fields) and delete that setting.
I could set "Null field value" = "Null" as a global default in the definition file, but it was not picking it up because for some reason ALL of the fields had the "Null field value" set to "" at the row level (i.e. "Edit Row")
So Now I have to go in and edit each row (50 odd fields) and delete that setting.