Importing List Formatted Line Items into List Formatted Line Items (Numbered List)

Hi,

I have been getting import errors when trying to import a line item formatted as a numbered list into a different line item formatted as the same numbered list. We import directly from our source into a list formatted line item and the only workaround I've been able to come up with is to make a new line item, make the formula CODE(other line item), and use the text formatted line in my export. Is there a way to have Anaplan match up values on an import by looking at the code, not the display name? This is for line items formatted as list items only.

Example:

There are two Jane Doe's at our company, both are managers. As an attribute of each employee at our company, we tag their manager. When I try to import the list formatted line item from our data hub into our workforce planning module, the Jane Doe lines are failing, I think because the name is registering as ambiguous.

Accepted answers

JaredDolich

@shanemcintosh

Exactly. In order for Anaplan to make a match it has to lookup one of the two primary keys of a list, the ITEM or the CODE. For numbered lists, the ITEM is not the display name, it's the system generated number which looks like "#1". You can certainly get this number and use that in the NAME mapping but it's hard to work with. CODE is usually the best bet.

Awesome!

All comments

JaredDolich

@shanemcintosh

Good question and sometimes hard to sort out. When you import using a line item formatted as a numbered list, you're actually loading the system generated number Anaplan assigned. What you want to do is exactly as you mentioned. Use the CODE.

Create a saved view from your source that contains the Display Name and Code and Parent if applicable (use code on that too)
When you import and map into your TARGET list, leave the ITEM empty, the code should be the code, parent the parent, and the display name into your list property.

Give that a try. you've got this.

shanemcintosh

Thanks Jared! I think this answers my question.

In this case, the list is already fully populated, the errors are occurring when importing Line Item 1 into Line Item 2, both formatted as that list. Even for imports within the same model, I get errors unless I make a new line item (CODE('Line Item 1')) and importing that into Line Item 2. It seems weird to me that Anaplan doesn't associate list members 1:1 for imports but that appears to be the case.

JaredDolich

@shanemcintosh

Awesome!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…