QUARTER FORMAT IMPORTING PROBLEM

jagadishdash

I have a csv file with Quarter value in this column header Q1_2022

we can't change the  column header format, so while importing I'm facing problem (Expected fiscal quarter number in date/period). 

Is there any solution of mapping to import the file without changing the csv file column header?

 

Thanks,

Jagadish Dash

ryan_kohn

You can set a custom Time mapping in the import settings. Try the below format for your case:

 

 

KirillKuznetsov

@jagadishdash 

Unfortuantely, you cannot adjust mapping in import settings to meet the desired format. But you can create a system list with quarters in this format and then map it to built-in time scale to pull the values.

jagadishdash

@ryan_kohn Yes i did it. I got this idea by trying randomly just before 3hr ago. Anyway Thanks for giving the solution and By this way we can achieve.

ryan_kohn

@jagadishdash Great news! If my posted solution worked, can you mark it as the solution to this question? Thanks!

jagadishdash

@ryan_kohn Done 🤗