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 can I Delete Users in Administration
Now I faced below warning But I cannot find any delete action for those users I don't need anymore Can I have any action to solve this warning?
Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…