How to Delete a column data if data is imported action


Hi Community,

Requesting for your inputs wherein,

I need to delete a column data wherein to create a empty staging module which in turn will be used a import action to main module in L3.

Requirement : to delete Override Sales Target column data

Below is the attached screenshot for more reference


Best Answer

  • CQuonoey
    Answer ✓

    Create an additional line item, such as "Delete Sales Target", use the same formatting as the existing "Override Sales Target". But in the formula hard code the values as "0" (zero). Then create a view which only includes the line items "Delete Sales Target" and "Override Sales Target". Create an import action which uses that view, and map so it uses input "Delete Sales Target" to output "Override Sales Target".

    This new import action can be the first step of a process, which first does this new action then does your existing import action.