Having trouble mapping a flat file

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

cf_question_95352.PNG

cf_question_1_95352.PNG

Accepted answers

ashish.banka

@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.

SandeepB

@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

ashish.banka

@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.

ChrisAHeathcote

@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

All comments

ashish.banka

Hope this helps.

SandeepB

@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

ashish.banka

@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.

ChrisAHeathcote

@neg177

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

neg177

I removed the formulas like you said and the data mapped beautifully.

Thank you

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!