Dataloss after Unpivot/Pivot

[rebmanna]

ok, found this Topic

Pivot back to original dataset

Hi, 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 ba…

seems to be a workaround