Time mapping issue

sp40684
Contributor

Time mapping issue

My Mapping looks like this

sp40684_0-1642817878278.png

 

What mappings needs to be done in the Time i can select the option for DD-MMM

Please guide

Regards,

Srini

 

1 ACCEPTED SOLUTION

Accepted Solutions
DeepakSrinivas
Occasional Contributor

Hi Srini, 

 

As per screenshot, data looks like its with Year and Month format not DDMM.

 

So you should match it with Period -> Y-M option. Try this.

 

 

Thanks,

Deepak Srinivasan

View solution in original post

4 REPLIES 4
ManjunathKN
Super Contributor

Hi

Try either for "Match periods" or "YM".

Thanks
Manjunath

DeepakSrinivas
Occasional Contributor

Hi Srini, 

 

As per screenshot, data looks like its with Year and Month format not DDMM.

 

So you should match it with Period -> Y-M option. Try this.

 

 

Thanks,

Deepak Srinivasan

sp40684
Contributor

@DeepakSrinivas ,

Thank you and now its loaded.

 

Have  a question, headers looks like DD-MMM ,  how  to get a idea to choose Y-M 

and reference to get more experience in the time mappings please share the link 

 

Once again thank you.

 

 

sobaid
Frequent Contributor

You might need to look at your csv or excel sheet to get Idea what date format it is in! Probably that solves your question!