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

Options
shanemcintosh
shanemcintosh Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

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.

Comments

  • shanemcintosh
    shanemcintosh Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

    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.