Ability to clear text formatted cells on import

Description of the enhancement:

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.

Comments

AnaplanIdeas

Description of the enhancement:
I'm trying to import blank values for a text field. Everything works fine, it is only, if there is a blank value, it is ignored. The requirement is to update a value in the cell with a blank using the import function.

We had "Clear target" option chosen for all our actions, initially. But it was causing data loss because most of our modules have multiple dimensions and users when uploading data were clearing other data uploaded by error.

AnaplanIdeas

Status changed to: In Review

hendersonmj

Workaround -
1) Create a "Clear Text?" line item (boolean) and a "Blank" line item (text),
2) Create a saved view with the Blank line item and filtered on Clear Text? = True.
3) Create import action from saved view.
4) Add True and False fields to data file.
5) Create two import actions that 1)Import True into 'Clear Text?' and 2)Import False into 'Clear Text?'
6) Four step import process:
Import True into 'Clear Text?'
Import from saved view
Import False into 'Clear Text?'
Import data without clearing data.

Quick Links

New ideas

Enable MFA for External Exception Users & Allow Multiple SSO Configurations per Workspace
As an Anaplan tenant admin, I want to enhance security for external users who are added as SSO exceptions by enabling Multi-Factor Authentication (MFA) for their accounts. Currently, these users authenticate with only a username and password, which poses a security risk. Additionally, I request the ability to assign a…
Limited Cross-Workspace Access to Archived Models
In Workspace A developed a model called XYZ2025, which was archived after the fiscal year ended. Months later, a regional team in Workspace B wants to use that model as a foundation for their XYZ2026. Here’s what happens: Workspace B cannot directly access or import the archived model. Workspace A must unarchive the model,…
UX Customization (negative sign): bracket or - (sign)
Hi All, Recently I have seen great customization to UX (numbers to percentage), it was really good when it comes to line item subset (combination of numbers/% value). It would be good if we are able to customize the negative sign in UX, as management would prefer to view numbers (if negative used bracket), % value (if…