Hi,
when using CSV/Live loader to correct data, what happens to the existing data, especially if it is not being replaced by, or included in the CSV file? is it retained or deleted?
cheers
My experience is that new data uploads replace the existing data but previously loaded data that is not included in the CSV is retained.
For example, if you load Export and then over-write using Export by TOU, the values get added together. When I add data with overlap like this, I zero out the alternative input streams to ensure I get the right overall result.
Records provided in the upload are added (if the are not present) or update (if present).
Existing records not present in the CSV are deleted.