I want to replace alle empty cells with “\N” in my dataset because when I export this to CSV I can import the empty values as NULL values in MySQL.
In an earlier post I have learned that a table wide replace is not possible. In order to avoid putting a replace of the type ifempty() for each column I thought I could achieve this by first unpivoting my dataset, do the replace and then pivot back to the original dataset. However, when performing the final step, it seems not possible to get back to the original dataset. I have posted some screenshots with a sample dataset. Why is it not possible to get alle the rows back as in the original dataset ?
It could also be handy to be able to specify a character value for empty() values when exporting to CSV.