Issue while Importing Dates in week format

Hi All,

I am trying to import data into my module however, i am not able to map the date format with the modules timescale, the date is in "Week 1 FY19" format and i am not sure which time scale format will be suitable for the same.

Thanks.

Accepted answers

Misbah

@sharmagh

If your time format is like "WEEK 1 FY19" then you should keep it as "Match Name" in Import Mapping. Let us know if you are facing any issues with that

Misbah

DmitryP

Hi Sharmagh,

If you navigate to Import settings, you are able to select the format you need either from already excising options OR the custom one, where "?" replace characters which should be ignored - see the screenshot below.

Hope that helps,

Dmitry

All comments

Misbah

@sharmagh

If your time format is like "WEEK 1 FY19" then you should keep it as "Match Name" in Import Mapping. Let us know if you are facing any issues with that

Misbah

DmitryP

Hi Sharmagh,

Hope that helps,

Dmitry

priyankshibisht1

Hi ,
I was doing this training and came across with the same issue .
Tried everything which was discussed above .
But I am still facing the issue in date in week format .
Nothing is working , can anyone help me with resolving this issue ?

PeterZ

The date should be formatted in - periods - custom fixed-position pattern : ???? W ??YY

Note the space must be added in after and before the question mark to match the custom date format otherwise the import won't work.

😅

Quick Links

Can you help?

Unanswered questions

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…