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?

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!🙂

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?

Rnilsson

Hi

I have created an example looking like this:

To map the time period you should have this mapping:

Hope this helps!

Prajjwal88

.

Lilich

thanks @Prajjwal88 it worked perfect

Lilich

Hi

AjayM

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

Cheers!