Set one column of source data as "Not Applicable" for this import

tingtingxia

Dear Anaplan Community 

 

I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module.

Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type 2 codes as well while budgeting.

 My target module has Plan Week, Team, Expense Type 2 and Time as dimensions. My current upload action mapping is like below. The numbers will still get uploaded correctly just that Anaplan will throw error message saying that the Code Column is invalid time identifier which is confusing for end users in terms of user experiences. Is there a work-around on such situation without changing my source file format and avoid the error message?

 

Appreciate any thoughts on this.

 

TT