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
This is a tough one, so I'll give you what I think is your best strategy.
Hope some of this helps. You can do this!
You are most likely have issues with mapping your time dimension. A few things to consider;
Try a few interations of the time mapping
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.
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