List matching error of importing data

Mick

Hi all,

Sorry for my vague question.

In our model, data import error is happend at the specific module when using "match on names or codes".

If I use "Map items manually", importing data always suceeds.

What is the possibilities of list unmatch cause do you think?

Thank you.

****

Accepted answers

Mick

Hi All,

Thanks to everyone's advise, we sloved the problem.

By matching code of numbered list istead of display name, the importing data proceeds successfully.

Thank you.

****

All comments

jon_mavetz

If your source or target is a numbered list, try creating a line item that is the code of that numbered list and map your list to the code. It's best practice to map Numbered lists with code. That should fix your issue.

Sheethal

As you are using "Match Name or Code" for the list I assume that you are not using Numbered List.

In a standard list, one of the reason for system mapping failure could be the usage of same name in parent hierarchy and child hierarchy. For example, if there are Region and Sub-region hierarchy and both the lists have "Europe" as a member (while creating the list member Anaplan will not give duplication error as its unique for that list), then the system mapping will fail. Same rule applies for code too.

If you can give the screen shot of the mapping or the list then it will be easy to identify the issue in your list.

Mick

Hi,

Thank you for your reply.

Actually we use "Numbered List". So we will try again to define Numbered List's code.

Regards,

****

Sheethal

In cases where you cannot implement code for the numbered list, alternatively you can use the Anaplan's system name (#1, #2, etc) for auto mapping list members.

Mick

Hi All,

Thanks to everyone's advise, we sloved the problem.

By matching code of numbered list istead of display name, the importing data proceeds successfully.

Thank you.

****

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…