Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi Community,
Just a quick question.
Maybe it is a bit of an uncommon request, but I have a table with many NULL values, and when I export it to CSV, this NULL values become empty cells. Is it possible to export the NULL value?
Cause these CSV file is used as input for a tool and it needs to read NULL values and not empty cells.
Thanks in advance.
Marc Robert
Hi Marc,
What you could try is inside of an Analysis (or in a Prepare), mass replace all your empty values by 'NULL' (select 'all' for applicable columns in the processor).
You can then export the dataset either directly from the Analysis Action tab or from your flow.
Hope this helps
โ
Hello Vince (@VinceDS),
When I try to do this, it will also change the storing type from decimal towards text.
And that is something that is not really prefered.
But thank you for your response.
Best wishes
Marc Robert