Mapping issues

Hi,

I'm having trouble mapping this excel sheet. Attached is a snap shot of what I'm trying to map and also the excel sheet I'm trying to map. Please advice.

Thank you

Accounts_FF_96489.csv

issues_with_mapping_96489.PNG

Accepted answers

All comments

JaredDolich

@neg177

This is a tough one, so I'll give you what I think is your best strategy.

First, the primary problem your facing is that you are using a Comma Delimited file and your text values have commas in them, not to mention you have a lot of special characters on the dollar figures, like "$". Commas are okay for numeric values. Anaplan is parsing your file thinking that each column is separated by a column. So, you guessed it, you have to use a different delimiter, or you have to remove the commas in the text values and the special characters on your numeric values.
Second, I would encourage you to reformat the spreadsheet. Remove column 1, for example. And remove all the rows that are summary values or empty. Also remove any other columns you don't need. If this is a spreadsheet that is a template and you'll have to do this often, I would recommend creating a macro that can reformat all future spreadsheets. Just turn the macro recorder on before you format the sheet.
Lastly, Add a unique identify in the first column that identifies what makes that row unique. You don't need the time hierarchy in that since you can dimensionalize time. Create a list from that first column, and a system module that contains the properties.

Hope some of this helps. You can do this!

ChrisAHeathcote

@neg177

You are most likely have issues with mapping your time dimension. A few things to consider;

Use a custom time mapping where you specify which part of the time header is day (d), month (m) and year (y). At first glance attempt DD/MM/YY
Remove the first column from you data as it will cause your mapping to return an error as the import will try and match this to a time period.
If you can make your time reference another column and map this into time instead of using the column headers option.

Try a few interations of the time mapping

ben_speight

To start with you'll need to set the text delimiter option in the file import data source settings to double quote (")

Note the time column heading is inconsistent in the file with a two-digit year until 3/14/19 and four digits thereafter - change to 4 digits throughout and a M-D-Y date format should work.

Anaplan's importer should cope with dollar signs (ignore) and parentheses (negate) in numeric cells.

I can't help on the line item front, though

neg177

I believe I'm just going to copy and past it into another csv file that as the same exact layout I have in Anaplan, and use that as my flat file.

Quick Links

Can you help?

Unanswered questions

ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…