Date format during CSV import

vivekpratap2015
Contributor

Date format during CSV import

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 :-

vivekpratap2015_0-1609689629302.png

 

Mapping Column view :- 

vivekpratap2015_1-1609689672551.png

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. 

vivekpratap2015_2-1609689724296.png

 

Module View :- 

vivekpratap2015_3-1609689995181.png

 

 

 

8 REPLIES 8
Misbah
Moderator

Re: Date format during CSV import

@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
Contributor

Re: Date format during CSV import

@Misbah 

 

Hey its Month only :- 

 

vivekpratap2015_0-1609747004669.png

 

Misbah
Moderator

Re: Date format during CSV import

 

 

 

 

vivekpratap2015
Contributor

Re: Date format during CSV import

@Misbah 

 

Hi , 

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

 

vivekpratap2015_0-1609748020936.png

 

Misbah
Moderator

Re: Date format during CSV import

 
rob_marshall
Moderator

Re: Date format during CSV import

@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
Moderator

Re: Date format during CSV import

@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
Moderator

Re: Date format during CSV import

@Misbah 

 

Too funny!