Allocate data of 1:N within same list.

swapnil_J

Hi,

I have a list with items A,B,C the data of A should be mapped to B and the data of C should be mapped to B.

and it is 1:N mapping

A1->B1

A1->B2

A2->B1

A2->B2

C1->B1

C1->B2

C2->B1

C2->B2

I have done the above mapping by creating a concatenated list but I am not able to fetch the data by using this mapping to target module dimensioned With B (list subset).

need alternative way to solve it.

Accepted answers

All comments

MarkWarren

This looks like you'd be better with a second list for B, the first list has items A and C. The mappings would be much easier to achieve.
Is this possible or is there a reason to include B in the list?

swapnil_J

Hi @MarkWarren

there is requirement

I have main list where I have all list items A1,A2, B1, B2, C1,C2..

I am capturing data with opposite to each list item,

but based on the percentage i need to allocate the cost of A's and C's in B (ignore percentage for now)

so I have created mapping module to map All A and C to B

Mapping data.JPG

Here In cost line item I am entering cost specific to B

In Total line item i want to sum B and cost of A and C into that specific B.

final data.JPG

kavinkumar

HI @swapnil_J,

Try this! Let's use only one list to achieve this.

Step 1: Create a mapping table module as below and make it as manual input,

Step 2: In the allocation module create 2 more line items and apply the below rules,

Then this is how the end result would look like,

Assumptions: 1. The list has Top Level Item, 2. With the help of the mapping table, the total cost will be allocated to the marked entries, here in this case B1 and B2 which takes the cost of all A and C entries.

Hope this helps

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…