Date format during CSV import

vivekpratap2015

Hi All,

I am trying to import the below CSV file to module, but unable to get the correct time mapping detail, any help will be appreciated .

CSV File :-

Mapping Column view :-

Time Dimension mapping view :- The problem is I am not getting the month neither under "Pattern and Separators" nor Fixed Position patterns. I think i need to do some changes with these mapping options rather than changing any date format in CSV file. Also the customized mapping is restricted under this import.

Module View :-

Accepted answers

All comments

Misbah

@vivekpratap2015

That is because you might have weekly timescale for the Model on the main Time Page. You will have to change it to Months from Weeks before you run the import.

Hope that helps

Misbah

vivekpratap2015

@Misbah

Hey its Month only :-

Misbah

vivekpratap2015

@Misbah

Hi ,

Below is the screens shot , can you please locate where exactly you are suggesting for change :-

Misbah

rob_marshall

@vivekpratap2015

@Misbah the problem doesn't look like a weekly timescale issue, the problem is most likely with Excel and how the monthly date is actually being stored vs how it is rendering.

@vivekpratap2015 even though you are seeing 20-Oct, click on the cell (within the CSV file) and see how the data is being stored. Then, you can set your mapping correctly on the action.

Rob

Misbah

@rob_marshall

First day after the holidays:) I swear I was sober:)

@vivekpratap2015 apologies for confusing you. It Indeed looks like formatting issue and not weekly timescale of your Model. Will delete my replies so that it doesn't create any confusion.

Misbah

rob_marshall

@Misbah

Too funny!

Quick Links

Can you help?

Unanswered questions

How to extract Previous Column Ending Balance as Current Opening Balance (without time dimension)
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…