Hi Anaplan Community,
I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site".
The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x Site" elements + the details.
Here’s the problem:
When I import the data, it successfully updates combinations like #4 - UK and #80 - France, but other existing combinations in the module (like #4 - France and #80 - UK) are deleted or overwritten with blanks.
What I want to achieve:
- Import and update only the combinations present in the source file (e.g.,
#4 - UK, #80 - France)
- Preserve the values of other existing combinations in the target module that are not included in the import (e.g.,
#4 - France, #80 - UK) - The saved view used as the import source is dynamic and filtered, so the mapping must be automatic, not manual, as list members can change. Because of this, it’s not possible to select "All mapped items" in the dimension mapping.
- If the "Only update imported cells" option is selected, importing blank text-formatted cells does not overwrite existing values — meaning it doesn't work for clearing existing text data.
- Has anyone encountered this situation before?
What’s the best way to import partial data into a two-dimensional module without clearing or overwriting existing combinations that are not part of the import?
Any help, tips, or best practices would be greatly appreciated.
Thanks in advance!
