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

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…