Fetching values from one module into another

I have two modules PROD and TRANS

TRANS module is having the dimension of TRANS and looks like this. Two line items PROD ID (List as Product) and boolean (checkbox).

Source	Product ID	Boolean Source
TRAN001	PROD001	TRUE
TRAN002		FALSE
TRAN003	PROD 003	TRUE

PROD module looks like this

Dimension of Product and line items as Source Boolean )Boolean) and Product (List Product)

	Source Boolean	Source Product
PROD001
PROD002
PROD003

End Result should be

	Source Boolean	Source Product
PROD001	TRUE	PROD001
PROD002	FALSE
PROD003	TRUE	PROD003

My problem statement is - there is no mapping module of having TRANSID AND PROD ID

I ran into the issues like "Automatic Sum" and "Dimension Mismatch"

Any pointes will be helpful.

I tried simple lookup and summary method like LASTNONBLANK etc. which did not work

Accepted answers

All comments

cbrookes

Here's how I think you could tackle this:

Source Product Formula in End Result module = TRANS.Product ID[LASTNONBLANK: TRANS.Product ID]

Source Boolean Formula in End Result module = ISNOTBLANK(Source Product)

Dikshant

@cbrookes, formulas looks correct but the Source Boolean is dependent on Boolean Source from TRANS module. In that case ANY function would be a better option for Source Boolean in scenarios where for a TRANS there is a Product present but Boolean Source is FALSE. End result Source Boolean must show FALSE even if the Product is present.

Source Boolean in End Result module:

TRANS.Boolean Source[ANY: TRANS.Product ID]

cbrookes

@Dikshant I agree that your solution is better! Thanks for sharing.

My solution assumed the Source Boolean will always be false if the product is NULL. Even if my assumption is correct, your solution is better from a performance standpoint because my solution uses daisy chaining.

Vamsi_Kaki

Hello,

What if, in the source module Same Product appeared multiple teams for different Trans and Boolean data is not depend on present of Product data. In that case, How can we pull Boolean data from source module

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385