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.
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 list||Description|
|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.|
|Parent||Map to the column that identifies the parent list. For example, Column 4: Product type.|
Map to the column that contains unique identifiers in your source data. For example, Column 2: Product SKU.
Note: Do not include hash symbols (
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.
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.
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:
- Create a line item in your source module to contain codes for each list item.
CODE(ITEM(List name))in the line item's formula editor. Learn more in CODE.
List nameis the name of your numbered list.
- Select Pivot and pivot the line item to Columns, then select OK.
- Select View > Save to save the module as a view.
- In your target module, select Data > Import > Connect to Anaplan Model > Saved View, then select your view.
- Map the Code property to the line item that contains the codes for each list item, then select Code as the unique identification method.
- Select Run Import.