Import of partial list

Hi All,

Is there any way i can import a part of list into a model from a huge list from another model?

Tags

Importing and Exporting Data

Modeling

Data Integration

Accepted answers

It is not best practice to import directly from a list to another list for exactly this reason. so:

1. Create a systems module dimensioned by the huge list and create two line items

Code: Formula = CODE(ITEM(huge list))
Filter = format this as a Boolean and make it true based on the criteria for the downstream import

2. Set the filter on the module using the filter line item and save this view

3. In the downstream model, use this view to import the name and the code to the target model. You don't need a line item for the name (unless the list is a numbered list, in which case use the display name)

I hope this helps

David

Hi Abhay,

Yes you can do this. You will have to import the destination list from a module in this case.

You can do it by 2 ways.

1. Create a subset and use it in a module and then create a list out of that subset

2. Mark the elements of the source list in a module as boolean, create a view out of this module when boolean line item is true and then import into the destination list from this view

Hope this helps

All comments

It is not best practice to import directly from a list to another list for exactly this reason. so:

1. Create a systems module dimensioned by the huge list and create two line items

Code: Formula = CODE(ITEM(huge list))
Filter = format this as a Boolean and make it true based on the criteria for the downstream import

2. Set the filter on the module using the filter line item and save this view

3. In the downstream model, use this view to import the name and the code to the target model. You don't need a line item for the name (unless the list is a numbered list, in which case use the display name)

I hope this helps

David

Hi Abhay,

Yes you can do this. You will have to import the destination list from a module in this case.

You can do it by 2 ways.

1. Create a subset and use it in a module and then create a list out of that subset

2. Mark the elements of the source list in a module as boolean, create a view out of this module when boolean line item is true and then import into the destination list from this view

Hope this helps

Thanks! @akhil.kohli @DavidSmith

It helped.

Quick Links

Can you help?

Unanswered questions

How to extract Previous Column Ending Balance as Current Opening Balance (without time dimension)
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…