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

Prajjwal88

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!

Prajjwal88

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!

Prajjwal88

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!

Prajjwal88

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

API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…