Set one column of source data as "Not Applicable" for this import
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.
This is a limitation of Anaplan. When importing data Anaplan must have the answer to two questions:
Where can I find the values for the lists in this module?
Where can I find the line items?
Since time is being used as a column, you'll be forced to fix the line item to one value unless the line items are all organized in a single column. The extra column you have is an property that belongs in a system module not within the transaction module.
Only suggestion I have is to see if it's possible to remove the column to avoid the errors. You can still use this file as-is but you'll get errors on the time dimension.