How do I get the data from a line item of a list in a module into another module?

I have two module. One call assumption, another. call Implied new room.

I want to get the data from the line item call mix which is base on my subscription list from the assumption module .

In my Implied new room module, I have 3 line item with the same name as my subscription list. I don't want to use a list because I want the format to be exactly how its picture. If I use a list, it will be nested/ filtered/column under Implied new rooms or become a dimension. How can I get the data from the mix line into my Implied new rooms module?

Screen_Shot_2019-06-30_at_4_48032.png

Accepted answers

kavinkumar

Hi @kdoan ,

Yes it is possible. Please follow the below steps.

Step 1: Create a look up module without dimension and create 3 line items and make it as 'Subscription list Formatted'

Step 2: Select the respective list items in all the 3 line items.

Step 3: In your destination module write the formula as mentioned below.

How do I get the data from a line item of a list in a module into another module.PNG

How do I get the data from a line item of a list in a module into another module 1.PNG

How do I get the data from a line item of a list in a module into another module2.PNG

How do I get the data from a line item of a list in a module into another module3.PNG

Hope this helps you!

Thanks,

Kavin.

All comments

kavinkumar

HI @kdoan ,

Quick question. In your source module you don't have time dimension or time formatted line item but in your destination module you have Month dimension, so how do you want to bring in the data?

And once you confirm the above one, you can create 3 more line items in your dimension less module and make those 'Subscription list' formatted. Then select 'Select','Premium' and 'Plus' from the drop down and use these line items for bringing in the data from 'Assumption Module' thru Lookup.

Ex: Assumption Module.Mix[lookup: Lineitem 1]

I don't want to suggest the function 'Select' and it is not preferable.

Thanks,

Kavin.

kdoan

@kavinkumar

I simply want to get the Mix % by the destination line item name and divide it by Implied New room. So essiantially, on my destination model of Implied New room, line item Select, I want that 15% from the Assumption Module for my Select Line Item.

Is there way to get number or do I have to bring in the Subscription list on my destination module?

kavinkumar

Hi @kdoan ,

Yes it is possible. Please follow the below steps.

Step 1: Create a look up module without dimension and create 3 line items and make it as 'Subscription list Formatted'

Step 2: Select the respective list items in all the 3 line items.

Step 3: In your destination module write the formula as mentioned below.

How do I get the data from a line item of a list in a module into another module.PNG

How do I get the data from a line item of a list in a module into another module 1.PNG

How do I get the data from a line item of a list in a module into another module2.PNG

How do I get the data from a line item of a list in a module into another module3.PNG

Hope this helps you!

Thanks,

Kavin.

kdoan

Thank you so much. You taught me something new.

Quick Links

Can you help?

Unanswered questions

Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…