Hi,
Having trouble loading in the attached data set. I'm getting a error with my time settings. Please advise.
The Flat File is attached.
Thank you
Error
Time Setting for the mapping
Blue Print of module
@neg177
Share the mapping window also
Hi @neg177
The Time custom mapping is correct. Make sure Time is mapped as Column headers in mapping window. If it isn't, map it as column headers. If the error still comes, share the mapping window and details window of error after scrolling to the right.
Thanks!
-Shubham
I have analyzed file which you have attached and below are my findings:
- you would have selected HEADERS for time dimension for Payment Amount lineitem and Fixed line item or Ask each time import is run option for other three lineitems.
This mapping will through error which you are getting because system is expecting time periods in other three lineitems.
I have loaded this file by spliting into files :
- I assume Remaining Kapitus RTR, IF_W/O and Write_Off_Date line items doesnot require time dimension.
so in first file I have kept only Contract ID Remaining Kapitus RTR IF_W/O Write Off Date and loaded to anaplan with below mapping. And I have removed time dimension from these three lineitems.
Now for the second file, I have removed three columns and kept only time columns and Contract id.
Loaded with below mapping.
Fixed line item to Payment Amount and loaded successfully.
Hope this helps.
Regards,
HD
@Harsha
Correct. If Time is mapped as Column headers and there are more than one line item in this file layout, it'll consider those line item as Time and will throw the error. I overlooked the number of line items.
Great observation. Kudos to you!
Is your saved view clean?(without summaries), where you are importing data.
Thanks,Manjunath
I see a floating control bar to copy-paste in your third screenshot. Can you please explain how you got it?
If someone else knows about it, please reply.
Thanks in advance!
- Shubham
Hi @GeorgeDuckett
Do you know how to get a floating control bar for click and paste function?
See my previous comment.
Hi @Harsha
Thanks for reply. I am already using the fomula editor extension by @GeorgeDuckett . It save a lot of time but it enhances the formula editor only, right.
Observe the red rectangle in my previous comment's image. There is a floating click and paste bar. I am looking for that.
Can any one share the link for A+ extension? I want to see what this one does extra than @GeorgeDuckett "s better formula extension.
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
