One thing that I observed in that context is that clay deletes my data if I match the results of a new column to an existing column, even if there is no data to write.
I will try it, but it is not a straight forward solution