Hi,
I'm having trouble mapping this flat file into my Module. It will not let me manually map my data when I choose that option. Please advise. Pics are attached.
Thank you
@neg177 It seems that the line items which are not mapped does not have any data in the source file, hence Anaplan engine is not allowing to map them manually. If you have values in those cells, it would either automatically map or allows manual mapping.
Hope this helps.
AB
@ashish.banka I wonder, not having the data in the source would impact the line item mapping?
@neg177, can you make sure the line items you are trying to map are not formula-driven? line-items that are mappable(input fields) are eventually showup in blue texts in the target section.
Thanks,
Sandeep
@sandeep_bkyou are correct. However I assumed that @neg177 would be trying to load data into input line item rather than formula line item.
I think it would be a great feature for Anaplan platform to disable mapping for those line item which does not have any data in the source file to avoid mistake.
@neg177
From your screenshot it would appear that all items that can be mapped in the target are allocated to a line item in the source. Unmapped items in the target will appear as blue in the box at the bottom right of the screen.
Ensure that all line items in the target which you want to import data into do not contain any formulas. Only empty line items will appear as mappable and will be marked in blue.
Good luck,
Chris
I removed the formulas like you said and the data mapped beautifully.
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
