QUARTER FORMAT IMPORTING PROBLEM

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

Accepted answers

ryan_kohn

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

All comments

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.

ryan_kohn

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

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 🤗

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?