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

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
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?