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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…