What is the proper way to create NULL fields when exporting to mysql?
I had blanks and it errored as incorrect.
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
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()
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.