nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Mapping time when importing csv file

Lilich

Hello

I have an issue when mapping the time when importing a csv file could you pleae help?

Accepted answers

Prajjwal Jar

Hi @Lilich ,

Try updating the Time mappings in Period settings as a Custom fixed-position pattern where you can set the custom-fixed pattern as "???YY". You may see an example mentioned below.

I hope this helps!

Prajjwal Jar

Hi @Lilich ,

You can try again setting up the Custom fixed-position pattern in time period setting as "?Q?YY".
Here's an example,

Hope this helps!🙂

All comments

Lilich

Hello community,

I am blocked when mapping the time when importing a csv file: my model is set as Year and in my csv file I have a colum named Year with FY. I have error when mapping those, please see images below. Can you please give me some ideas?

Capture d’écran 2024-11-07 à 11.12.56.png

Capture d’écran 2024-11-07 à 11.13.15.png

Rnilsson

Hi

I have created an example looking like this:

To map the time period you should have this mapping:

Hope this helps!

Prajjwal Jar

Hi @Lilich ,

Try updating the Time mappings in Period settings as a Custom fixed-position pattern where you can set the custom-fixed pattern as "???YY". You may see an example mentioned below.

I hope this helps!

Lilich

thanks @Prajjwal88 it worked perfect

Lilich

AjayM

Try this custom pattern for time mapping, it should work.

Cheers!

Prajjwal Jar

Hi @Lilich ,

You can try again setting up the Custom fixed-position pattern in time period setting as "?Q?YY".
Here's an example,

Hope this helps!🙂

Quick Links

Can you help?

Unanswered questions

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…