NULL values for exporting to mysql?

KNIME Analytics Platform
1

What is the proper way to create NULL fields when exporting to mysql?
I had blanks and it errored as incorrect.

2

Hey jsh562,

Have you tried the Missing Value node? This node will handle missing values and replace them as the way you want.

1 Like
3

that was the first thing I tried, and I couldn’t get it to work the way I wanted. Does that actually work for what I am trying to do? It seemed to just remove missing rows completely.

I ended up using string manip with tonull()

4

Hi @jsh562 -

Glad you found a way.

In many cases the Missing Value node can help treat NULL data, but in your specific case to create a NULL value, it can require a bit of a trick, which you found :slight_smile:

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.