Data import vs named list with hierarchy

Hi,

i fance the problem during the data import - once i want to copy data from one line item to another in the same module i get duplicate values in some fields. After some investigation i realized that on my one dimension (named hierarchy list) i have the same name of member but on different level ex. Level4 - Duties and child level5 Duties as well (whole module applies to level5). During the import "duties" member was duplicate and Anaplan do not recognize that there are two different members with hierarchy relation...

How to resolve it and make my import correct ?

Thanks in advance,

Tomasz Stuglik

Accepted answers

filip.sypniewski

@Tomek,

for the saved view you are using for import, did you select only the lowest level? I think that should solve it. I think at this moment, you load both level 4 and level 5 from your saved view to level 5 in another line item. If you:

- clear your current load on the line item you copy data

- go to your saved view

- use select levels to show and choose only lowest level

- save your view

- run action matching based on codes

I think you should achieve correct result, does it help?

All comments

Puneeth H P

Hello ,

Please attach screenshot so that it would be more helpful to analyze .

You can try giving Level 5 Duties and Level 4 duties a unique Code .

Lets say Level 5 Duties - AAA having code - 1A

Level 4 Duties - AAA having code - 1A4 ( Combining Level 5 and level 4 in code )

then you can try importing based on Code .

Regards,

Puneeth HP

Tomek

Hi,

thanks for answer. It also was my hint to code the list but unfortunately it's not working in my case. Please see attached screens.

I admit that i has mark 'match on names or code' option in import.

Regards,

Tomasz Stuglik

import_issue_anaplan_sent_83161.png

list_code_sent_83161.png

filip.sypniewski

@Tomek,

- clear your current load on the line item you copy data

- go to your saved view

- use select levels to show and choose only lowest level

- save your view

- run action matching based on codes

I think you should achieve correct result, does it help?

Tomek

Hi @Filip ,

many thanks for your help - indeed it's resolve the issue!

Thanks,

Tomek

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385