Mapping time when importing csv file

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?

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!

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