The two options of "Clear target prior to import" and "Only update imported cells" are not sufficient, as if you select to clear all, it clears ALL the text, not retaining any previous info, and if you select "only update imported cells" you do not have the ability to clear any cells, only update them if it contains text in the source.
The customer is importing a file with blank values for the text cells in the source file, which they want to use to overwrite what is currently in the text cells. Current behaviour does not overwrite the cells with the blank values.
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.