Model builders can import into numbered lists from external sources, such as a CSV file.

Create or convert any numbered lists you might need in General Lists in the model settings bar.

To import into a numbered list, you must first set up the import. Once you have set up the import, you can then map the list items.

Import mapping for numbered lists

When you import into numbered lists, the mapping process differs to standard lists.

For example, you must map the Code property to unique identifiers in your source data. If your list contains product SKUs, you can use them to identify the list items you want to import. Refer to the table below for a description of each mapping property.

Property in listDescription
List name (For example, #Products)You must ensure that this field is empty. When the import is in progress, unique identifiers are created for each list item.
ParentMap to the column that identifies the parent list. For example, Column 4: Product type.
Code

Map to the column that contains unique identifiers in your source data. For example, Column 2: Product SKU.

Note: Do not include hash symbols (#) at the beginning of codes in your source data.

Display name

Map to the column that contains the name of each list item. For example, Column 1: Product.

Learn more in Create display names in numbered lists.

When the mapping is complete, select Code as the unique identification method, then select Run Import.

Warning: When you import new list items into a numbered list, it's important that you do not select Name (#ID) as the unique identification method. Name (#ID) refers to the unique identifier that is created for each list item when the import is in progress. However, you can map on Code or Name if you want to edit existing list items.

If the import does not recognise a code, a new list item is created with the next available unique identifier. 

Import codes into numbered lists

You can import codes from external sources into existing list items in a numbered list. Codes must be unique.

When you define the mapping, map the unique identifiers created by the import to the List name property. Map the unique identifiers from the source data to the Code property, then select Name (#ID) as the unique identification method.

When the import is complete, each list item in the numbered list updates with a new code.

Import into a module with numbered lists

If you import into a module that contains a numbered list, you can create line items that pull in codes using a formula. When you define the mapping, map the Code property to the line item that contains the codes for each list item.

Note: If you import a blank parent for an item that already has a parent, this removes the parent.

To import into a module with a numbered list:

  1. Create a line item in your source module to contain codes for each list item. 
  2. Type CODE(ITEM(List name)) in the line item's formula editor. Learn more in CODE.
    Note: List name is the name of your numbered list.
  3. Select Pivot and pivot the line item to Columns, then select OK.
  4. Select View > Save to save the module as a view.
  5. In your target module, select Data > Import > Connect to Anaplan Model > Saved View, then select your view.
  6. Map the Code property to the line item that contains the codes for each list item, then select Code as the unique identification method.
  7. Select Run Import.