Mapping issues

neg177

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 

issues_with_mapping_96489.PNG

Accounts_FF_96489.csv

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!