I am having an issue connecting SPSS Modeler 18.3 & 18.4 to DB2WoC Databases - Null values rendered as the value in the previous record.
For instance record 1 contains the values - 1,2012-12-12,<null>,"Strength"
record 2 contains the values - 2,<null>,17,"Bluebell"
record 3 contains the values - <null>,<null>,<null>,<null>
These are being rendered as :
record 1 - 1,2012-12-12,<null>,"Strength"
record 2 - 2,2012-12-12,17,"Bluebell"
record 3 - 2,2012-12-12,17,"Bluebell"
Any ideas how to solve this?
Expected results were:
record 1 - 1,2012-12-12,<null>,"Strength"
record 2 - 2,<null>,17,"Bluebell"
record 3 - <null>,<null>,<null>,<null>