How to Delete a column data if data is imported action

Karthik31

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

Thanks.

CQuonoey

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.

Karthik31

Thank you @CQuonoey

This worked for me.

nvilkko

You can also use 'No Data' as the format for the new "Delete Sales Target" line item. Then it won't take any extra space :)

Karthik31

Hi @nvilkko

Thanks for the suggestion used the same data type accordingly.