import duplicate list item

how can i import duplicate data from excel to list : remember there is no parent or code with in excel i only want to import main channel please check screenshot

THANKS in advance

Screenshot_2021-10-18_202417_122519.png

Screenshot_2021-10-18_203608_122519.png

Accepted answers

All comments

anand.shekhawat

@Saurabhkumarkunwar

You cannot load duplicate data into a list unless and until that list is marked as a numbered list. If your data has duplicate list members/items I would advice you to use the numbered list.

~Anand

Saurabhkumarkunwar

@anand.shekhawat i have used numbered list and get this error

please help...

check both screenshot

Screenshot_2021-10-18_204735_122522.png

Screenshot_2021-10-18_205013_122522.png

anand.shekhawat

@Saurabhkumarkunwar

Could you please show me the mapping that you have done.

~Anand

Saurabhkumarkunwar

@anand.shekhawat this is my mapping

Screenshot_2021-10-18_203608_122527.png

rob_marshall

@Saurabhkumarkunwar

Before you start going down the path of a numbered list and since you don't have a code, how many unique values do you have in the first column? That should be a flat list (no hierarchy). Same thing with the LOB (2nd column).

Then, create a module dimenisonalized by Time as well as those two new lists (1st column and 2nd column) and import the transactional data into that module.

Take a look at this for more information on loading data:

https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

Rob

Saurabhkumarkunwar

@anand.shekhawat here is my mapping

Screenshot_2021-10-18_203608_122575.png

Shrankhla

Hey @Saurabhkumarkunwar

I would suggest to please consider the solution provided by @rob_marshall first if the Main Channel & LOB are going to remain constant.

However, if in your case, the new LOBs or Channels are being created on ad hoc basis then as you have done so far:

1. Create a numbered list, just like you've done already.

2. Create a list property "LOB".

3. Map this new LOB list property with the LOB column from your csv while importing data.

3. In you import definition, select "Combination of Properties" as items uniquely identified by.

Attaching your import screenshot with my comments for your reference.

Thanks,

Shrankhla

Screenshot_2021-10-18_203608_122617.PNG

rob_marshall

@Shrankhla

While combination of properties can work, you should try to avoid using this feature as much as possible as it will require you to load all metadata and transactional data via the use of properties as there will not be a true code defined. Additionally, it adds longer load times because the system will have to "figure" out the uniqueness of each row when inserting a new member.

A couple of Planual rules to remember:

https://community.anaplan.com/t5/Chapter-1/1-05-02-Always-use-a-code/ta-p/71177

https://community.anaplan.com/t5/Chapter-1/1-05-03-Avoid-using-List-Properties/ta-p/71178

https://community.anaplan.com/t5/Chapter-1/1-05-04-Numbered-List-should-always-have-a-code/ta-p/71179

Hope this helps,

Rob

Thanks,

Rob

Quick Links

Can you help?

Unanswered questions

ADO - On Premise MSSQL Server Connector
I’m trying to understand how Anaplan Data Orchestrator (ADO) connects to an on-premises SQL Server. In Anapedia, I found this: An MSSQL instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider. The solution is compatible with on-premises SQL…
How to get most recent actual year value into a non-time (staging) module and use it for forecast ca
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…
Access model data outside of assigned workspaces?
I'm using the Integration API 2.0 to list workspaces https://anaplan.docs.apiary.io/#ListUserWorkspaces /workspaces "Retrieves all workspaces a user has access to within the user's default tenant." I'm only assigned to 2 workspaces (which are the only ones visible in the UI also), but this endpoint is returning everything.…