Mapping timescale during import and ignoring some columns

I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time.

Attaching screen shots for your reference.

In the source file attached , the first column simply maps to the list whereas the next five columns needs to be imported into a different destination and can't be get rid of. After these five columns I need the data to be imported for respective time periods.

When I map the Time to Column headers, I get an error because of these five columns.

I can't remove these columns from the source file,neither can I map them to a list.

Can anyone provide me any solution on how do I get rid of the error. We can change the source file format if necessary but cannot ask the user to upload separate files.

Any help would be appreciated

. Source File.PNG

Accepted answers

DavidSmith

Unfortunately with column headers with time, if you don't map all of the non time columns it will show as an error as @aakash showed

It would be better with two files, but as you said this is not an option, although, you can still add both actions into one process; the user would just have to run a single update, but choose two files as part of that process

David

karank_*4578

@aakash

You mentioned that changing file format is an option

Is it possible to unpivot the data file like below

Screen Shot 2019-06-05 at 3.35.13 am.png

Then you can import it like

Screen Shot 2019-06-05 at 3.37.51 am.png

All comments

anirudh

Hi Aakash,

I imported a similar file (screenshot below) into an Anaplan module dimensioned by list 1. The columns XYZ and ASD are similar to the columns you want to ignore in your file

and the data imported successfully. Here is the mapping I used in the import options:

The only error I got was the one below (which can be safely ignored)

Result after importing

Please let me know if this is helpful

Regards,

Anirudh

DavidSmith

Unfortunately with column headers with time, if you don't map all of the non time columns it will show as an error as @aakash showed

David

karank_*4578

@aakash

You mentioned that changing file format is an option

Is it possible to unpivot the data file like below

Screen Shot 2019-06-05 at 3.35.13 am.png

Then you can import it like

Screen Shot 2019-06-05 at 3.37.51 am.png

ben_speight

An alternate option - this is not normally recommended as it makes the import quite brittle - is to set the header row to zero in the file data source. This will cause all mappings to be numbered columns, meaning the columns in the source file must always appear in the same position/order for it to work. As there are no longer any names to match, Anaplan will require you to either map to a time slot or ignore any otherwise unused column.

aakash

@anirudh
Thanks for the answer , but the users would not normally understand the meaning of the error. That's why I was trying to remove this error.

aakash

Hi Everyone

Thank you so much for your suggestions and solutions.

Aakash

paolovm

hi @DavidSmith

are you aware of any request on idea exchange that covers a fix for this?

would be amazing to eliminate this as an error.

maytheforcebewithlin

Same issue here, can't remove the columns as they were used to show users the meaning of data, and I don't want users to see the error when uploading, annoying.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…