Referencing line item of module into list

Hello Friends,

I use the import from module functionality to update the list from a module line item. However since its a manual process and the list wont get updated for any changes in the line item of module unless i again start the import process, is there any way wherein i can reference the line item of module in the formula bar of the list

Thanks in advance

Accepted answers

ryan_kohn

Because you need to insert a new item into the target list, it needs to be done via an import action.

When do new cities get added into the City list? This is something you would typically want to load in from a data hub via an upstream system. The best approach here would be to add the City-SKU import action into that automated data ingestion process.

All comments

ryan_kohn

Can you expand on the overall process? e.g. what data in stored in the module that you are importing into the list? How does this copy-over of data fit into the overall business process? How is the original source data updated over time and how often?

Some initial thoughts:

It is certainly possible to write a formula that refers to module data (this capability is core to Anaplan). The formula can be written into a module line item (recommended), or into a list property (not recommended per our best practices).
You still need to run an action to do one of the below things:
- Insert an item into a list
- Delete an item from a list
- Update the NAME, CODE, or PARENT associated with a list item

Khanolkr

@ryan_kohn Eg. I have created a module [Attachment] which has a line item which combines City_SKU Combination which combines the names of 2 list. I wish to create a combination list from the module line item. Hence i do import into list from module.

When i insert one City to the City list, the module will by default contain the city, but the list created from module.line item wont be updated and i would need to manually do the import once again after updation. However i wish to have this process automated

Hence i created numbered list with a property and wish to add formula in the property to reference the module.line item. And am looking for any idea about the formula

City_SKU_Module_147460.jpg

ryan_kohn

Because you need to insert a new item into the target list, it needs to be done via an import action.

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?