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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…