Error when using DB Insert with nullable columns and NaN

Pay attention.
NaN and NULL are different things!
You can insert NULL on double nullable field but you cannot insert a NaN.

Are your NaN values “” (empty string) values.
If the answer is “yes” then you have to substitute these values with NULL (missing value) before DBInsert node. (you can use this hint: replace empty cell with missing (?) globally in table)

5 Likes